RE: [PHP] Can someone check this mysql code

Try this.. <?php > > $answers="$band, $middlename, $pot"; > $date=date ("l dS of F Y h:i:s A"); > > $sql = "INSERT INTO prizeline VALUES ('', 'email', 'name', > 'address', 'answers', > 'date');"; -Balaji -----Original Message----- From: Miguel Cruz [mailto:mnc@stoic.net] Sent: Monday, May 20, 2002 11:12 AM To: PhilipNZ Staff Cc: php-general@lists.php.net Subject: Re: [PHP] Can someone check this mysql code On Mon, 20 May 2002, PhilipNZ Staff wrote: > My code below don't want to insert the code into the database what am > I doing wrong? > > <?php > > $answers="$band, $middlename, $pot"; > $date=date ("l dS of F Y h:i:s A"); > > $sql = "INSERT INTO prizeline > (id, email, > name, address, > answers, date) VALUES > ('', 'email', 'name', 'address', 'answers', > 'date');"; What is the error message shown when you printed mysql_error() ? And you probably don't want the semicolon at the end of the query string (the one inside the double quotes). miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

**************************Disclaimer************************************************** Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ****************************************************************************************