error on line 9

alighouston

What am i doing wrong

<html>
<body>
<?php

// connect to database
$connect = mysql_connect ("localhost", "data_base", "anypass") or die ("lost")

//active data base
mysql_select_db ("data_bella") ;

//create "purchase invoice tablefood" called purchf
$purchf = "CREATE TABLE purchf (
auto_id bigint (200) NOT NULL auto_increment,
Invoice_num int(20) NOT NULL,
desc_prod varchar (255) NOT NULL,
date_purc date NOT NULL,
amm_pur int(20) NOT NULL,
primary key (auto_id),
)" ;

$results = mysql_query($purchf)
or die (mysql_error() ) ;

echo "done";
?>
</body>
</html>

NogDog

No semi-colon at the end of the connect line.

PS: please make use of the [noparse]

...

[/noparse] tags when including code snippets in your poses.

alighouston

now error on line 8

NogDog

Please post the modified code (within [noparse]

...

[/noparse] tags 😉 ).

alighouston

<html>
<body>
<?php

// connect to database
$connect = mysql_connect ("localhost", "data_base", "anypass") or die ("lost") ;

// data base selecte
mysql_select_db("data_bella") ;


//create "purchase invoice tablefood" called purchf
	 $purchf = "CREATE TABLE purchf (
	auto_id bigint (200) NOT NULL auto_increment,
	Invoice_num int(20) NOT NULL,
	desc_prod varchar (255) NOT NULL,
	date_purc  date NOT NULL,
	amm_pur int(20) NOT NULL,
	primary key (auto_id),
)" ;

$results = mysql_query($purchf)
	or die (mysql_error() ) ;

echo "done";
?>
</body>
</html>

NogDog

There are no syntax errors. It might help if you tell us exactly what error message you receive.

alighouston

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 8

NogDog

That's a big difference: it's talking about line 8 of your database query, not line 8 of your PHP code. You need to get rid of the comma after the primary key(auto_id).

alighouston

thanks for the help i think i need focus more on the , and ; thanks