Re: Weird Problem

In article <005f01c34126$4740d620$17d310ac@yggdrasil>, theheadsage@manga- 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;