After CREATE TABLE yet another problem

Databases
1

What’s wrong with this please, it’s not doing what I expect it to do. In fact it does nothing.

Thanks,

Mike

<?php
include(“misc.inc”);
$connection = mysql_connect($host,$user,$password)
or die (“No connection”);
$db = mysql_select_db($database,$connection)
or die (“No selection”);
$query = “INSERT INTO books(booknumber,title)
VALUES(01,‘sudoku’)”;
$result = mysql_query($query, $connection)
or die (“No query”);
$query = “INSERT INTO books(booknumber,title)
VALUES(02,‘Jobhunters’)”;
$result = mysql_query($query, $connection)
or die (“No query”);
$query = “INSERT INTO books(booknumber,title)
VALUES(03,‘HTML’)”;
$result = mysql_query($query, $connection)
or die (“No query”);
$query = “INSERT INTO books(booknumber,title)
VALUES(04,‘An Irishman’)”;
$result = mysql_query($query, $connection)
or die (“No query”);
?>

2

It was working after all. I don’t know what I missed. Thanks for your time.

3

Nothing? It doesn’t insert the rows, and it doesn’t display a message?
And this is all the code there is?