[BlackVenom]

I've been trying to pass this through for quite a bit but I can't figure out what's wrong.

mysql_query("CREATE TABLE scMain(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
scuser VARCHAR(20), 
scmsg VARCHAR(90)")
 or die(mysql_error());

I get the error "You 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 5". Which makes me assume it's the the line with scmsg VARCHAR(90)"). I've tried multiple variants of this code w/ no success in creating a table.

This post has been edited by BlackVenom: 17 April 2010 - 09:32 AM

[atik97]

Here is the corrected sql syntax-

CREATE TABLE scMain(
id INT NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( id ) ,
scuser VARCHAR( 20 ) ,
scmsg VARCHAR( 90 )
);

What you have done is missing the closing ')' which was generating an error.

[Fratyr]

BlackVenom,

To avoid SQL errors, I would recommend to use/test your queries in PhpMyAdmin application, It's more comfortable than trying to execute SQL query through PHP without a lot of experience in SQL syntax.

[BlackVenom]

Ah, thanks! I figured it was one little detail... and thanks for the tip Fratyr.

EDIT: Doesn't work; here's the full code this time.

<?php
// connect
mysql_connect("localhost", "USER", "PASS") or die(mysql_error());
mysql_select_db("scriptc_sctst") or die(mysql_error());

// create
mysql_query("CREATE TABLE scMain
(
    id INT NOT NULL AUTO_INCREMENT, 
    PRIMARY KEY(id),
    scuser VARCHAR(20), 
    scmsg VARCHAR(90)"
))
 or die(mysql_error());  

echo "Table Created!";

?>

THat gives me "Parse error: syntax error, unexpected ')' in mysqt.php on line 12"


EDIT: success...

mysql_query("CREATE TABLE scMain(
id INT NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( id ) ,
scuser VARCHAR( 20 ) ,
scmsg VARCHAR( 90 )
)")
 or die(mysql_error()); 

This post has been edited by BlackVenom: 17 April 2010 - 10:04 AM