Adding command for MySQL

[GodSpeed]

I am learning PHP through a book ("SAMS: PHP & MySQL Web Developement"), and the way it explains how to insert new records into databases is the following:

$query = "insert into books values
           ('".$isbn."', '".$author."', '".$title."')";

But its not working? and it doesnt really explain what those variables are, though i would think they are the values going into the DB. Can anyone help?

[johnn]

Hello,
Please post more codes,not just one line so that someone here can help you.

[GodSpeed]

sorry:

@ $db = mysql_connect("localhost", "bookorama", "bookorama");
mysql_select_db("books");
$query = "insert into books values
         ('".$isbn."', '".$author."', '".$title."')";
$results = mysql_query($query);

that is the example code that the book provides. But it doesnt work for me on f2s.com. I go to browse my table and it is empty.

[DR_LaRRY_PEpPeR]

are you assigning values to $isbn, $author, and $title somewhere?

[GodSpeed]

yes.

[RKuhle]

Is it resulting in any form of error? Or does the script process correctly?

[Paul S]

Originally posted by DR_LaRRY_PEpPeR
are you assigning values to $isbn, $author, and $title somewhere?

Please give us a specific example of this values, ie, $author = "...., etc

[HarryF]

Might help if you get mysql to report any errors.

If you replace;

$results = mysql_query($query);

with

if ( !$results = mysql_query($query) ) {
       echo ( "<p>" . mysql_error() );
} 

At least you have an idea then where the problem lies.

[freddydoesphp]

Also is isbn in the primary key. If there is an extra column in there like an auto-incrementing, then using the INSERT ... VALUES (.....) needs to have an arg for every field in the table. Try using SET instead

$query = "insert into books set isbn = '$isbn', author = '$author', title = '$title'";
$result = mysql_query($query) or DIE(mysql_error()); 

[sonique]

is that code for a form of any sort. That's probaly is where your variables "('".$isbn."', '".$author."', '".$title."')";" might be set...