This is my first post here so, hopefully I will get some good responses. I have no idea why this table just does not come up on my Database table list. I have tried loads of things, any suggestions? It's probably some stupid error I'm missing.

Thanks a lot.

<?

$user="****";
$password="****";
$database="mydb";

mysql_connect(localhost,$user,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query="CREATE TABLE joborder

(id int(6) NOT NULL auto_increment,
title varchar(25) NOT NULL,
number varchar(15) NOT NULL,
desc text(200) NOT NULL,
category varchar(20) NOT NULL,
salary varchar(10) NOT NULL,
addcomp varchar(20) NOT NULL,
position varchar(20) NOT NULL,
location varchar(20) NOT NULL,
details text(350) NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id),
KEY id_2 (id))";

mysql_query($query);
echo("Success!");

?>

OK, well I figured something out, I changed the

mysql_query($query);
echo("Success!");

to

$result = mysql_query($query);
if($result)
echo "Success!";
else
echo "There was an error!" . mysql_error();

but then I got..

There was an 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 'desc text(200) NOT NULL, category varchar(20) NOT NULL, sal

column names cannot contain spaces

Ah I feel like an idiot, but what do you mean? I tried this: but I still got the same error..

$user="andiamop";
$password="1200baud";
$database="mydb";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE joborder
(id int(6) NOT NULL auto_increment,title varchar(25) NOT NULL,number varchar(15) NOT NULL,description text(200) NOT NULL,category varchar(20) NOT NULL,salary varchar(10) NOT NULL,addcomp varchar(20) NOT NULL,position varchar(20) NOT NULL,location varchar(20) NOT NULL,details text(350) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
$result = mysql_query($query);
if($result)
echo "Success!";
else
echo "There was an error!" . mysql_error();
?>

sorry mis read the list

text fields don't have a size parameter so you cannot have text(nnn)

Ah! Freakin' amazing. Thanks a lot.