Problem with PHP and MySQL

eam · 08-24-2004, 01:19 PM

I'm reading a MySQL tutorial and this is the first script I put together. When it's run I get the failed on insert 1 error. What's wrong?

Code:

<?php

include("conf.php");

$connection = mysql_connect($host,$user,$pass) or die ("Failed to connect<br>\n");

$db = mysql_select_db($database,$connection) or die ("\nFailed to select<br>");

$query = "CREATE TABLE bookx3 ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,  title varchar(50),  author varchar(50),  description varchar(255),  price varchar(10),  PRIMARY KEY (id),  UNIQUE id (id))";
mysql_query($query) or die ("Failed on making the thing<br>");
$query = "INSERT INTO bookx3 VALUES ('the book','some guy','a book.','$1000')";
mysql_query($query) or die ("Failed on insert 1<br>");
$query = "INSERT INTO bookx3 VALUES ('the other book','who knows','the greatest book ever written','$0.02')";
mysql_query($query) or die ("Failed on insert 2<br>");

?>

Cedrik · 08-24-2004, 02:00 PM

You try to Insert a string ("the book") where mysql expects an integer (id tinyint(4))

Try to change your insert line by something like :

INSERT INTO bookx3 VALUES ('','the book','some guy','a book.','$1000')

eam · 08-24-2004, 02:33 PM

I added the 1 and 2 back to the beginning and it worked. Before it didn't so I took the numbers out. Oh well. Thanks.