Help with Creating a MySQL table in PHP

[John V]

Hi,

 

I'm trying to create a table in PHP.  I can use phpmyadmin to do it but I can't create it in PHP.  I even copied the code generated in phpmyadmin and it still didn't work.  Here is the code I wrote:

 

<?php

mysql_connect("localhost", "familyon_john", "woosha") or die(mysql_error());

echo "Connected to MySQL<br />";

 

mysql_select_db("familyon_blog") or die(mysql_error());

echo "Connected to Database";

 

// Create a MySQL table in the selected database

$query="CREATE TABLE `familyon_blog`.`test3` (

`day2` DATE NOT NULL ,

`age` INT NOT NULL ,

`name` VARCHAR( 7 ) NOT NULL ,

PRIMARY KEY ( `day2` )

) TYPE=MyISAM"

or die(mysql_error()); 

 

echo "Table Created!";

 

?>

 

This is the code I copied from phpmyadmin:

 

CREATE TABLE `familyon_blog`.`test` (

`home` VARCHAR( 20 ) NOT NULL ,

`address` VARCHAR( 30 ) NOT NULL

) ENGINE = MYISAM

 

I looked at the post by Drags111 and incorporated those changes, but it still didn't work.  Here is the output I get when I run the script:

 

Connected to MySQL

Connected to DatabaseYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 7

 

Thanks for any help you can give me!

[greengo]

don't put the db's name in the query to create the table

[John V]

I tried that and a whole bunch of things, but still can't get it to work

[~n[EO]n~]

Try like this

<?php
$cnn=mysql_connect("localhost","familyon_john","woosha");
$db=mysql_query("create database familyon_blog");
print" DATABASE familyon_blog CREATED <br>";

mysql_select_db("familyon_blog",$cnn); 

//---------------------- CREATE TABLE HERE ---------------------------------	
$qry=mysql_query ("CREATE TABLE test3 (
`day2` DATE NOT NULL ,
`age` INT NOT NULL ,
`name` VARCHAR( 7 ) NOT NULL ,
PRIMARY KEY ( `day2` )
) TYPE=MyISAM"
or die(mysql_error()); 
print"TABLE  test3 CREATED <br>";

?>