RE: [PHP] Re: <Newbie Question> Can't insert values into MySQL DB via PHP

Also when specifying the field list (and table name) it may be a better idea to wrap the values in backticks (`) rather than quotes (') Always works for me Dan -----Original Message----- From: Barry [mailto:barry@Flyerheaven.de] Sent: 10 February 2006 10:31 To: php-general@lists.php.net Subject: [PHP] Re: <Newbie Question> Can't insert values into MySQL DB via PHP Duggles Temple wrote: > Hi, > > I'd like to say in advance that I am sorry about the silly and very newbie > question I'm asking. > > I am having a problem with a shop system. I can't add values into the MySQL > DB via a PHP statement. The values are being transferred from one page to > another (know that from the echo statement), but the SQL statement isn't > working. > What error do you get? > The statement is as follows: > > $conn = mysql_connect($DBhost,$DBuser,$DBpass) or die('Unable to connect to > database'); > $t = $_GET['newdvdtitle']; > $y = $_GET['newdvdyear']; > $c = $_GET['newdvdcost']; > $p = $_GET['newdvdpurchased']; > @mysql_select_db("$DBName") or die("Unable to select database $DBName"); > $sqladd = "INSERT INTO 'dvd' ('id', 'title', > 'year','cost','purchased') > VALUES ( NULL , '$t', '$y', '$c' , '$p' )"; > echo $sqladd; > $result = mysql_query($sqladd); Insert Into dvd (title, year,cost,purchased) When the id is auto_increment you dont have to add it to the query. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php