Thanks Everyone, That's working now - This is my first time on this list and I have to say I'm stunned how quickly my question has been answered! I used Kim's code and it worked a treat!
:-) Phil Clandillon -------------------------------------------------- Graphic and Interactive Design -------------------------------------------------- work: http://www.clandillon.com play: http://www.mrming.co.uk ----- Original Message ----- From: "Kim Cosgrove" <[EMAIL PROTECTED]> To: "Phil Clandillon" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 4:40 PM Subject: RE: newbie PHP/mySQL query > Hi Phil, > > You need to change your SQL to > > $sql="SELECT * FROM news ORDER BY datetime DESC" > > Actually, you may need to rename that field since datetime is a keyword. > > Kim --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
