If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script:

<?php
include "mysqlconnection.php";

$sql = "CREATE TABLE example ("
. " id INTEGER NOT NULL" 
. ", url VARCHAR(80) NOT NULL"
. ", notes VARCHAR(1024)"
. ", counts INTEGER"
. ", time TIMESTAMP DEFAULT sysdate()"
. ")";
if (mysql_query($sql, $con)) {
print("Table example created.\n");
} else {
print("Table creation failed.\n");
}


mysql_close($con); 
?>

Remember that mysql_query() returns TRUE/FALSE on CREATE statements.

Please login or Register to submit your answer
Not the answer you are looking for? Browse other questions tagged or ask your own question.