Error 200- Mysql create table

oxygen · - Joined: 13 Mar 2005 Posts: 2

DAMMIT! Ive looked EVERYWHERE on this forum and tried basicly every solution to this error 200 thing.

Anywho, when I try to create a table in mysql it comes up with error 200. I have changed the global thing to 'on' in the php.ini file.

heres the code

<?php
$DBhost = "localhost";
$DBuser = "***";
$DBpass = "******";
$DBName = "***";

$connection = @mysql_connect($DBhost,$DBuser,$DBpass);
echo "$connection";

mysql_select_db("$DBName") or die("Unable to select database $DBName" . mysql_error() );

$sql = "create table users("
"ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, " .
"dateofbirth TINYINTUNSIGNED,".
"quote text,".
"namefirst char(20),".
"namelast char(20),".
"email char(255),".
"username char(255),".
"minitar char(255),".
"password char(255),".
mysql_query($sql)

?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
</body>
</html>

I dont think theres any thing wrong with the code.

Glitch2082 · - Joined: 02 Dec 2004 Posts: 194

You didn't close the $sql string for create table... and you didn't add the delimiter.
Edit: also, your breaking out with the double quotes i believe...

$sql = "create table users('
'ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, ' .
'dateofbirth TINYINTUNSIGNED,'.
'quote text,'.
'namefirst char(20),'.
'namelast char(20),'.
'email char(255),'.
'username char(255),"'.
'minitar char(255),'.
'password char(255),'.)";
_________________
int main() {
cout << "Im Pro Apache";
cin.get();
}

aprelium-beta · - Joined: 24 Jun 2004 Posts: 383

oxygen · - Joined: 13 Mar 2005 Posts: 2

Errrr. Sorry.

I tried the 'replacement' code Glitch gave me and it still returned the error.

Oh, Its not my server im using, a friends, I better check it out.