RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql

This also works: INSERT INTO vcstats VALUES( NULL,column2,column3,column4,column5) The NULL value will be replaced with theauto-incremented value in the table -----Original Message----- From: Ricky Theil [mailto:rtheil@quark.com] Sent: Monday, October 29, 2001 10:26 AM To: 'biorn@ebmstpa.com'; Robby Whiteside; php-db@lists.php.net Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql If your first field is an auto insert field, then you have to do it like this: insert into tablename (column2,column3,column4,column5) values (value2,value3,value4,value5) The auto incremented field will be automatically be filled in with the next available value. Ricky -----Original Message----- From: biorn@ebmstpa.com [mailto:biorn@ebmstpa.com] Sent: Monday, October 29, 2001 9:24 AM To: Robby Whiteside; php-db@lists.php.net Subject: Re: [PHP-DB] HELP PLEASE!! Get query error when inserting into MySql If any of the values you are trying to insert are not integers, you need to put single quotes around the variables, ie. $SCRIPT_NAME, $date, $BName, etc in the insert statement. Robby Whiteside <robby@thedatasource.net> said: > Hi There, > > I have a query whenever I try to insert something into a mysql table. > This is > the code I am using: > <? > > $host1 = gethostbyaddr("$REMOTE_ADDR"); > $date = date("Y-m-d h:i:s"); > $link = mysql_connect("$host", "$user", "$passwd"); > mysql_select_db("$database", $link); $sql = "INSERT INTO vcstats > VALUES('', $SCRIPT_NAME, $date, $HTTP_USER_AGENT, > $BName, $BVersion, $BPlatform, $REMOTE_ADDR, $host1)"; $result = > mysql_query($sql) or die("query error<Br>" . mysql_error()); > mysql_close(); > > ?> > > Thanks, > Robby > > --------------------------------------------- > This message was sent using Endymion MailMan. > http://www.endymion.com/products/mailman/ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net