parse error

[Anon]

hi all

i hope someone can help here , i am a bit new to this

i get a "parse error on line 18"
could someone please point the error out and suggestions as to fix it.(code below)

<?php
$user="username";
$password="password";
$database="computersniagara";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE computersniagara (
computersniagaraDate date DEFAULT '0000-00-00' NOT NULL,
computersniagaraID tinyint(4) NOT NULL auto_increment,
computersniagaraCost char(50) DEFAULT '0' NOT NULL,
computersniagaraText char(50) DEFAULT '0' NOT NULL,
KEY computersniagaraID (computersniagaraID),
mysql_query($query);

mysql_close();}
?>

Thanks
mike

[majik-sheff]

You're not closing your quote on the SQL query

[Anon]

thankyou for the help,
but as i said , i am new to this, and am not sure what to close it with, or where the closing is missing - have tried a number of suggestions from other threads on this same problem, and i still get the same result

[majik-sheff]

$query="CREATE TABLE computersniagara (
computersniagaraDate date DEFAULT '0000-00-00' NOT NULL,
computersniagaraID tinyint(4) NOT NULL auto_increment,
computersniagaraCost char(50) DEFAULT '0' NOT NULL,
computersniagaraText char(50) DEFAULT '0' NOT NULL,
KEY computersniagaraID (computersniagaraID))";

[Anon]

Thankyou very much
mike

[techek]

You'll be doing yourself and other coders a big favour by indenting your code like this :

<?php

$user="username";
$password="password";
$database="computersniagara";
mysql_connect(localhost,$user,$password);
if (!mysql_select_db($database)) {
die( "Unable to select database");
} else {
$query="
CREATE TABLE computersniagara (
computersniagaraDate date DEFAULT '0000-00-00' NOT NULL,
computersniagaraID tinyint(4) NOT NULL auto_increment,
computersniagaraCost char(50) DEFAULT '0' NOT NULL,
computersniagaraText char(50) DEFAULT '0' NOT NULL,
KEY computersniagaraID (computersniagaraID)";

mysql_query($query);
mysql_close();
}

?>

By indenting your code, you'll group the code in a logical way and thereby speed up reading of the code (when read by humans!) The PHP parser won't mind it by the way.

[majik-sheff]

Hey, wow, the website stripped your tabs too! I thought you knew something the resot of is didn't. 😉