Creating MySql tables using PHP

[jase35750]

Somebody please help me. I've trying to develop a database. I want a new table with it's own fields for every new project that surfaces over time. I've gotten PHP to connect to my MySQL database which is using a Linux O/S (Red Hat 7.1). I can perform queries with no problem. My issue is:

I can find no source code that invokes:

$sql = "CREATE TABLE '$table_name'('a_unique_field_name'FIELDTYPE(length))";

I don't get a syntax error at execution but I do manually check the MySQL database on the Linux platform I have, and the table never gets created. How do I invoke $sql in the above statement to actually create the table. I want to start first with just manually having PHP create a table.....and once I figure how to code the statement, replace the table name with a variable ('$project') for every new project that comes into being.

If you guys could help me out, I'd be forever appreciated. I'm running around in circles, and the boss wants to know what the deal is. I'm so frustrated because of time restraints.

Sincerely,

[e-mail]

[amcgrath]

First, I don't use MySQl, so my advice may be a bit suspect: check to ensure the user account used to create the table has priviliges to actually create tables.

Second, why not just create generic tables and, as new projects come along, just insert them?

[trooper]

Jason

One of the best ways to create/delete/mange table is to use phpMyadmin

It's a package written in PHP to do exactly what you are describing. Why struggle with horrible syntax errors when there is something already out there that is cool

grab it fomr
http://phpmyadmin.sourceforge.net

and never look back !!!

Thats not to say actually knowing the raw elements (PHP and MYSQL) is a bad idea (I started outhand coding mysql commands and PHP by hand.

Also if you haven't got a bokk yet get one. Honestly they really do help.

My first MYsql book which was brilliant was MYSQL by Paul Dubois from new riders (and no i'm not on commission)

Any problems drop me a line

Gary Mailer