Create table script

Anon

Hey I am really confused. I am trying to just create a simple table using PHP script. Check this code out and let me know what I am doing wrong. There is no errors in the code and I don't know how to get the MySQL errors. Thanks!

<?php
$db = mysql_connect("localhost","1","1");
mysql_select_db("abc",$db);
$sql = "Create Table multi (
multi_id INT NOT NULL AUTO_INCREMENT,
end_date TEXT,
Primary Key(multi_id))";
mysql_query($sql);
?>

Anon

Is it really that difficult of a question? B/c I usually get a really good response quickly. Just wondering. Thanks!

theslinky

i don't think there is a variable called "TEXT". change it to VARCHAR(NNN) where NNN is an integer from 1 to 255.

you can you tinytext, mediumtext and longtext as well

and no: it's not that hard. sometimes people just don't bother testing sql queries if they can't spot the mistake off the top of their heads (like me :-).

i suggest you try out your sql queries either from the command line or a program like phpmyadmin (http://phpmyadmin.sourceforge.net) before using them in your PHP. this is the better way of figuring out what's wrong w/ the query.

also, make sure you have the host,username,password correct in the mysql_connect function.

-sridhar

Anon

Yea i have done this a million times using the mysql> prompt... but I don't want to use it. B/c I have 56 fields. Thats a lot! 🙂 Hey I was going to E-Mail you. You rock dude. I have been reading everything you write and really enjoy the reading. I am glad to see that 17 y/o's are rocking. b/c I am 19. So I can relate. Check out www.brokenformula.com its my new startup. If you ever get bored please IM me sometime. Chads2k2. Lata bud!
Chad