Re: Can anyone tell me why this code doesn't insert anything?

From: Date: Mon, 23 Feb 2004 17:19:56 +0000
Subject: Re: Can anyone tell me why this code doesn't insert anything?
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-178544@lists.php.net to get a copy of this message
Change your query line to this: $result = mysql_query($query) or die(mysql_error()); What does it output? On Mon, 2004-02-23 at 12:11, Brian Dunning wrote: > 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); -- Adam Voigt adam@kotisprop.com

« previous php.general (#178544) next »