WampServer

I am using this code to create some tables in a database..

<?php
$con = mysql_connect("localhost","peter","abc123";
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}

// Create table in my_db database
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE person
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);

mysql_close($con);
?>

But it doesn't seem to work. I've checked in phpmyadmin and there are no tables created.

Is Wamp disabling table creation?

Hi,

If you are creating a new database, I assume your user does not have any access rights to the newly created database.

Please note that giving users universal access rights to all the databases is not very secure.

Regards,

toivo
Sydney, Australia