Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- newbie DB update question
- Hal Halloway
January 23, 2005, 3:16 pm
rate this thread
variables hold the correct data because I echo them and it's OK. The
user has the grant for update...is this code OK?
$update_url = "UPDATE howto_temp.url_pages SET page_url= $temp_url
WHERE page_id = $posted_pk";
Re: newbie DB update question
You need to single quote your inserted values
$update_url = "UPDATE howto_temp.url_pages SET page_url= '$temp_url'
WHERE page_id = '$posted_pk'";
If you follow every mysql_query with a conditional execution of
you will almost always get an easy to decipher message about what was
wrong with your sql syntax.