PC Nerd Posted February 14, 2007 Share Posted February 14, 2007 hey quick QQQ, my query is below. but its updating every record on the database. whats going wrong. thanks $Upgrade_SQL = "UPDATE Table SET ".$Upgrade_Name." = '1' WHERE User_ID = '".$_COOKIE['User_ID']."'" thankx Quote Link to comment Share on other sites More sharing options...
Daney11 Posted February 14, 2007 Share Posted February 14, 2007 Whats the rest of your code? Could you post the full script. Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted February 14, 2007 Share Posted February 14, 2007 echo out the query to your browser and then copy it into your db app (phpmyadmin or similar) and check the result of the query. The problem clearly lies with the WHERE clause so make sure that is spot on. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.