On Friday 22 November 2002 00:46, Griffiths, Daniel wrote: > the statement runs without errors, its just the output thats wrong (see the > two tables) I'm displaying the results by doing a simple dump of the query, > through my own code and have also tried through phpMyAdmin. Not sure if this could be the problem -- where are you getting MONTH from and does it start at 0 or 1? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* I saw Lassie. It took me four shows to figure out why the hairy kid never spoke. I mean, he could roll over and all that, but did that deserve a series? */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php