Still think we need to see the PHP code before determining that it is an SQL problem. Regards, J -----Original Message----- From: Jason Wong [mailto:php-db@gremlins.biz] Sent: Thursday, November 21, 2002 11:55 AM To: php-db@lists.php.net Subject: Re: MySQL Problem 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