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 Link to comment https://forums.phpfreaks.com/topic/38454-sql-update-error/ 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. Link to comment https://forums.phpfreaks.com/topic/38454-sql-update-error/#findComment-184495 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. Link to comment https://forums.phpfreaks.com/topic/38454-sql-update-error/#findComment-184500 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.