<html>
<head>
<title>Create guestbook table</title>
</head>
<body>
<?php
$conn = @mysql_connect("localhost", "userName", "password") or die("Could not connect to database");
$rs = @mysql_select_db("my_database", $conn) or die("Could not select database");
$query = "id int(4) auto_increment, name varchar(50),";
$query.= "email varchar(50), comments text, ";
$query.= "time timestamp(14), primary key(id)";
$sql = "create table guestbook($query)";
$rs = @mysql_query ($sql);
if( $rs )
{
$msg = "<h3>Created guestbook table</h3>";
}
else
{
$msg = "<h3>Could not create guestbook table";
$msg.= "<br>Does it already exist?</h3>";
}
echo($msg);
?>
</body>
</html>
|