Create Table proble

[mkumar]

Hallo Everybody !

Following is my code. Could any body can specify where I'm commiting error as I receive the error "created table slq failed" which means the sql query I'm using failed to execute. If possible then please give me correct code instead for that

<?php
$link= mysql_connect ("Localhost","macky","jacky");
mysql_select_db("mac",$link)or die("connection failed");
$rs=mysql_query("CREATE TABLE t1 (Hoopy VARCHAR(30), Frood VARCHAR(10) NOT NULL)") or die("created table slq failed");
$query = "SELECT * FROM t1";
$result = mysql_query($query) or die("Query failed");
print "<table border=1>";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "<tr>";
foreach ($line as $col_value) {print "<td>$col_value</td>";}
print "</tr>";
}
print "</table>";
mysql_free_result($result);
mysql_close();
echo ("hallo");
?>

Than you in anticipation.
Mukesh Kumar

[[deleted]]

First of all, start using proper error checking:

or die("created table slq failed");

this tells you nothing at all, but this:

or die(mysql_error());

will tell you exactly why mysql failed to execute your query.