can anyone tell me why this query dies....

[miles_rich]

 

   $query = "CREATE TABLE  bt_quote (uid INT (6), cust_id INT(6), travel_date TEXT, pick_ups TEXT, travel_time TEXT, passengers TEXT, from TEXT, destination TEXT, return_time TEXT, return_point TEXT, price TEXT, datetime DATETIME, db_src TEXT)";
$result = mysql_query($query) or die("Query failed bt_quote");  

print "Table bt_auth was created...<br>";  

does anyone have any ideas why this would die???

[KoshNaranek]

..., passengers TEXT, from😕 TEXT, destination TEXT,...

You have an error in your SQL syntax near 'from TEXT...

FROM is a reserved word!

SELECT From FROM bt_quote??? Sounds bogus 😃
Try "source" or "startpoint"

The "or or"-thing (next reply) is not needed
:rolleyes:

[hand]

Try it with this OR statement, you will get more informations

$query = "CREATE TABLE  bt_quote (uid INT (6), cust_id INT(6), travel_date TEXT, pick_ups TEXT, travel_time TEXT, passengers TEXT, from TEXT, destination TEXT, return_time TEXT, return_point TEXT, price TEXT, datetime DATETIME, db_src TEXT)";
$result = mysql_query($query)
	or or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

print "Table bt_auth was created...<br>";

[steveryan]

i find that sometimes if my SQL query fails it still create the table. maybe drop the table first and then create it in your query?