just started learning php mysql dont know if i am doing this right
trying to create a database with 4 columns
this is what i have so far
<html>
<head>
<title>
mysql databser
</title>
</head>
<body>
<? php
$new_db = "testDB2";
$connection = mysql_connect("localhost", "craig", "1978");
if (!$connection)
{
die("Could not connect to the server");
}
$result = mysql_create_db($new_db, $connection);
if ($result)
{
$msg = "Congrats! Your database has been created!";
}
else
{
die("Could not create a new database");
}
?>
<p><?php echo $msg; ?></p>
</body>
</html>
mysql>creat database testDB2;
mysql>use testDB2;
mysql>create table table_name (
column_1_name column_1_type column_1_details,
column_2_name column_2_type column_2_details,
column_3_name column_3_type column_3_details,
column_4_name column_4_type column_4_details,
...
);
mysql>create table dbmyrestaurant (
Itemid int not null auto_increment primary key,
);
can any one help me please
thanks
