Thread: Mysql Error Out Of Nowhere
View Single Post
  #1  
Old 08-14-2006, 02:46 PM
kingkong kingkong is offline
Junior Member
  
Join Date: Aug 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
kingkong is on a distinguished road
Default Mysql Error Out Of Nowhere
Correct this error please, thanks

Code:

$query = "UPDATE `users` SET `picture` = '$file_name' WHERE `username` ='$username'"; echo "debug: functions $query"; mysql_query($query); echo mysql_error(); echo mysql_info();
results in:

debug: functions UPDATE `users` SET `picture` = 'blahblah3964.gif' WHERE `username` ='blahblahusername'Rows matched: 1 Changed: 1 Warnings: 0

and yet...no rows were changed! I checked the entire database!

picture is a varchar, by the way. and file_name is a string. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - Mysql Error Out Of Nowhere
Thread: Mysql Error Out Of Nowhere
View Single Post
  #1  
Old 08-14-2006, 02:46 PM
kingkong kingkong is offline
Junior Member
  
Join Date: Aug 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
kingkong is on a distinguished road
Default Mysql Error Out Of Nowhere
Correct this error please, thanks

Code:

$query = "UPDATE `users` SET `picture` = '$file_name' WHERE `username` ='$username'"; echo "debug: functions $query"; mysql_query($query); echo mysql_error(); echo mysql_info();
results in:

debug: functions UPDATE `users` SET `picture` = 'blahblah3964.gif' WHERE `username` ='blahblahusername'Rows matched: 1 Changed: 1 Warnings: 0

and yet...no rows were changed! I checked the entire database!

picture is a varchar, by the way. and file_name is a string. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote