PHP mySQL problem

Anon

Hi guys, I am trying to create, insert and query a database but it is not working.
Here is my code.
Thanks for helping!

<body>
<?php

$db = mysql_connect("localhost","username","password");

@mysql_select_db("database") or die("Unable to select database");
$query = "CREATE TABLE tabletest (name char(30) NOT NULL)";

mysql_query($query);

$query = "insert into tabletest values ('name')";
mysql_query($query);

$query = "SELECT * FROM tabletest";
$result = mysql_query($query);
$num_results = mysql_num_rows($results);

for($i = 0;i<$num_results;$i++) {
	$row = mysql_fetch_array($results);
	echo "$row[\"name\"]";	
}

?>
</body>

[deleted]

You could at least tell us what the problem is...

amcgrath

I'll put $5 its cuz table name is already there....

Anon

I am sorry Vincent, the problem is that there is no output.
I don't have access to SSH on the server so I don't know if the table name is already there or not (is there a way using just php?)

I try to uncomment the table creation and the insertion of data but it still didnot work. I echo $num_results but nothing is displayed. The page is blank.

Thanks for helping.

jsagara

Try changing
echo "$row[\"name\"]";

to
echo $row["name"];

The outer quotation marks are redundant.