Need a little mySQL help

1

Okay… First I created the table… I checked it with phpMyAdmin. Heres my setup.php


<?php
@mysql_connect('localhost', 'root', 'password');
@mysql_select_db('testdb') ;
$query="CREATE TABLE shoutBox (
id INT PRIMARY KEY auto_increment,
userName VARCHAR(20),
userShout TEXT (1000)
);";
mysql_query($query);
mysql_close();
?>

But now this part isn’t working out quite right… Any help? What am I doing wrong?


@mysql_connect('localhost', 'root', 'password');
@mysql_select_db('testdb') or die( "Unable to select database");
$query="INSERT INTO shoutbox VALUES ('','Michael', 'I'm on top of the worldd!!')";
mysql_query($query);
printf ($query);
mysql_close();