At 08:00 AM 4/25/01 +0200, Herman Wapenaar wrote:
I am using a website based in the states to which is PHP enabled. I am
using MySQL.
Is there a way to create a table with PHP? I do not see any command for that.
Well, as an Oracle administrator, I may be going out on a limb here
regarding
Check your MySQL docs for exact syntax on table creation ... then:
Connect to the database
Build a SQL statement that does what you want:
$sql = CREATE TABLE blah, blah ..;
Execute the statement:
$result = mysql_query( $sql );
and check for errors, etc.
Alternately, if this is a
Hi Herman,
I am myself a pro at PHP, but I think, this would be of some help to you.
To create a Table, you won't find a comand in PHP. However what you do is build a
CREATE TABLE statement and pass that as an
argument to mysql_query() function to do the job.
Here is a small example:
Hi Herman,
Try something like this...
$dbname = my_db;
$tablename = my_table;
$table_def = item_id MEDIUMINT DEFAULT '0' NOT NULL AUTO_INCREMENT,;
$table_def .= item_name VARCHAR(50) BINARY NOT NULL,;
$table_def .= lastaccessed TIMESTAMP(14),;
$table_def .= PRIMARY KEY (item_id),;
$table_def