how to create table for database use php?

[vivi6666666]

how to create table for sql database with php ?

can you give a example.

[bernouli]

ie.

<?php
//your connection to db

$query="CREATE TABLE `test` (
`a` INT NOT NULL, 
`b` TEXT NOT NULL,
PRIMARY KEY (`a`)
)"; 

if(mysql_query($query)) echo "success";
else echo "failed";
?>

[vivi6666666]

I can't thank you enough, i ok,thank!!!!

[vivi6666666]

Originally posted by bernouli
ie.

<?php
//your connection to db

$query="CREATE TABLE `test` (
`a` INT NOT NULL, 
`b` TEXT NOT NULL,
PRIMARY KEY (`a`)
)"; 

if(mysql_query($query)) echo "success";
else echo "failed";
?>

[/B]

if a int(5) unsigned DEFAULT '0' NOT NULL auto_increment,

default '0' how to default,can tell me for example
thank!!!