Thread: Mysql Error Out Of Nowhere
View Single Post
  #2  
Old 08-14-2006, 02:48 PM
roberto roberto is offline
OSP Starters
  
Join Date: Mar 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
roberto is on a distinguished road
Default
You could try updating the query like this, not sure but you can try
php Code:

$query = sprintf("UPDATE `users` SET `picture` = '%s' WHERE `username` ='%s'", mysql_real_escape_string($file_name), mysql_real_escape_string($username));
Try printing the relevant portion of the db before and after the change to see if there is any difference whatsoever. Maybe set $blah = mysql_query($query); and verify $blah is okay? -- 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
  #2  
Old 08-14-2006, 02:48 PM
roberto roberto is offline
OSP Starters
  
Join Date: Mar 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
roberto is on a distinguished road
Default
You could try updating the query like this, not sure but you can try
php Code:

$query = sprintf("UPDATE `users` SET `picture` = '%s' WHERE `username` ='%s'", mysql_real_escape_string($file_name), mysql_real_escape_string($username));
Try printing the relevant portion of the db before and after the change to see if there is any difference whatsoever. Maybe set $blah = mysql_query($query); and verify $blah is okay? -- 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