Creating a table with mysql and php.

[wayzer]

Hello me again,

I am trying to create a table in php connecting to a mysql DB. I have tried a number of different formats and they have not worked. I have searched the internet for more examples and nothing is working. Could someone maybe take a look at it and tell me what I am doing wrong. I will give you my most recent code attempt.

<?php

$connection=mysql_connect("localhost", "root", "") or die("Could not connect!");
mysql_select_db("tutorial_db", $connection) or die("Could not select a valid DB");

$sql = CREATE TABLE person ( id INT NOT NULL AUTO_INCREMENT ,
name VARCHAR( 35 ) DEFAULT 'Noname' NOT NULL ,
surname VARCHAR( 35 ) DEFAULT 'Nosurname' NOT NULL ,
sex VARCHAR( 1 ) NOT NULL ,
age SMALLINT UNSIGNED NOT NULL ,
PRIMARY KEY ( id ) );

mysql_query($sql);
mysql_close();

?>

Thanks,

Wayzer

[anjanesh]

<?php
$connection=mysql_connect("localhost", "root", "") or die("Could not connect!");
mysql_select_db("tutorial_db", $connection) or die("Could not select a valid DB");

$sql = "CREATE TABLE person ( id INT NOT NULL AUTO_INCREMENT ,
name VARCHAR( 35 ) DEFAULT 'Noname' NOT NULL ,
surname VARCHAR( 35 ) DEFAULT 'Nosurname' NOT NULL ,
sex VARCHAR( 1 ) NOT NULL ,
age SMALLINT UNSIGNED NOT NULL ,
PRIMARY KEY ( id ) )";

mysql_query($sql);
mysql_close();
?>

[Adam A Flynn]

www.mysql.com and download MySQLcc or google phpMyAdmin, download, and install that. They're both reasonably good MySQL front-ends, that will make creating/editing tables and such simple.

Otherwise, mysql_query($sql) or print(mysql_error()); will print the MySQL error.

[wayzer]

Thanks, It was the double quotes around the create table string. Silly mistake I guess, but that is why we all love programming.

Thanks again guys.