problems with mysql

[safe]

any help??

<h3> Press RELOAD to add a record to the MySQL database:</h3>
<?
//establish user connection
mysql_connect("localhost");
//open up database
mysql_create_db("testdatabase");
mysql_select_db("testdatabase");
//create table
mysql_query("CREATE TABLE newone(firstName VARCHAR(25),lastName VARCHAR(25))");
mysql_query ("INSERT INTO newone (firstName, lastName) VALUES ('Amir', 'Khan')");
//display the information
$result = mysql_query ("SELECT * FROM newone");
while($row = mysql_fetch_array($result))
{
print ("Added record: " . $row["firstName"]." ".$row["lastName"]." <br>\n");
}
//close user connection
mysql_close();
?>

i doesn`t work!!

[laserlight]

When your script is under development, and you're not sure what is wrong, use standard debugging techniques.
e.g.

<h3> Press RELOAD to add a record to the MySQL database:</h3>
<?php
error_reporting(E_ALL); //for debugging
//establish user connection
mysql_connect("localhost")
	OR die(mysql_error()); //for debugging
//open up database
mysql_create_db("testdatabase")
	OR die(mysql_error()); //for debugging
mysql_select_db("testdatabase")
	OR die(mysql_error()); //for debugging
//create table
mysql_query("CREATE TABLE newone(firstName VARCHAR(25),lastName VARCHAR(25))")
	OR die(mysql_error()); //for debugging
mysql_query ("INSERT INTO newone (firstName, lastName) VALUES ('Amir', 'Khan')")
	OR die(mysql_error()); //for debugging
//display the information
$result = mysql_query ("SELECT * FROM newone")
	OR die(mysql_error()); //for debugging
while ($row = mysql_fetch_array($result))
{
	echo "Added record: " . $row["firstName"] . " " . $row["lastName"] . " <br>\n";
}
?>