In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] sketchbook.org says... > Hey, > > I've got a script which disables a banner image when it's time is up, the script > also sends an e-mail to both me and the banners owner when the time is up > > I've got a problem which is really weird.. > > Everything else works, but when the query is sent to the MySQL database, nothing > happens... > > This is the query being sent: UPDATE st_banners SET Disabled='Y' WHERE > BannerID='$bannerid' > > But when the script is run, it reports no errors, yet when i do SELECT Disabled FROM > st_banners they are all enabled. I then echoed the query and the result it said it > sent the query and it all worked, but the database was never updated..
If it works, why doesn't it work?? You can use mysql_affected_rows to test whether an update changed any records. You might also try echo-ing the query and feeding it into phpMyAdmin or the command line sql to see what happens. > Any thoughts or suggestions? Or should i be looking for a MySQL list? Suggestion: set Outlook to wrap lines at around 74 characters :-) -- Quod subigo farinam $email =~ s/oz$/au/o; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
