creating table

[rinteractive]

i am new to mysql, table is not creating even there is no error message. The code i have used below.

 

<?php

$con = mysql_connect("localhost","root","");

if(!$con)

{

echo"Connection failed".mysql_error();

}

mysql_select_db("project",$con);

$sql= "CREATE TABLE `experience` (

`id` int(11) unsigned NOT NULL auto_increment,

`years` int(11) NOT NULL,

 

PRIMARY KEY (`id`)

) TYPE=MyISAM";

mysql_query($sql,$con);

 

mysql_close($con);

?>

 

Please any one help me

[adam291086]

change

 

mysql_query($sql,$con);

 

to

 

mysql_query($sql,$con) or die(mysql_error());

[rinteractive]

Thanks Adam

 

my problem is solved now, your code helped me a lot 

[adam291086]

you should always include error reports. They help us debug. You can also put error_reporting(E_ALL); at the top of your code. It helps with errors