Create table

[jpenguin]

My site is being hosted on www.110mb.com
I tried to fallow an online tutorial, but I still get e rrors

<?php
// Make a MySQL Connection
mysql_connect("localhost", "jpenguin_root", "*******") or die(mysql_error());
mysql_select_db("jpenguin_brain") or die(mysql_error());
 
// Create a MySQL table in the selected database
mysql_query("CREATE TABLE example(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
 name VARCHAR(30), 
 time VARCHAR(30), 
 comment VALCHAR(100)")
 or die(mysql_error());  
 
echo "Table Created!";
 
?>

I get, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALCHAR(100)' at line 6"

I'm trying to learn about MySQL, that's why I'm not using a GUI tool

[prabirchoudhury]

mysql_query("CREATE TABLE example(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
name VARCHAR(30),
time VARCHAR(30),
comment VALCHAR(100)")
or die(mysql_error());

you have a data type spelling mistake on

comment VALCHAR(100)"
 

would be

comment VARCHAR(100)"
 

:))

[jpenguin]

LOL, I can't believe I did that :-)

[prabirchoudhury]

thats happen some time.. :))