Re: Can anyone tell me why this code doesn't insert anything?
| From: | Adam Voigt | 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