Can anyone tell me why this code doesn't insert anything?
| From: | Brian Dunning | Date: | Mon, 23 Feb 2004 17:11:55 +0000 |
| Subject: | Can anyone tell me why this code doesn't insert anything? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-178540@lists.php.net to get a copy of this message | ||
This inserts nothing into the database, but returns no error that I can see. How come? What's wrong with it?
$dbname = "my_database";
$dbconnection = mysql_connect("mysql05.powweb.com","my_user","my_pass");
mysql_select_db($dbname, $dbconnection);
$query = "INSERT INTO invoices ('ip','total','creation','first_name','email','session','last_name') VALUES ('0.0.0.0','0.00',NOW(),'Bob','name@domain.com','12345','Smith')";
$result = mysql_query($query);