Install Help

[lMattz]

I am installing a members area and whenever i view the file to install it it says:

**** error: parse error, unexpected T_STRING (file locations) in line 23. (The Line In Red)


<?php

include ("config.php");

// connect to the mysql server
$link = mysql_connect($server, $db_user, $db_pass)
or die ("Could not connect to mysql because ".mysql_error());

// select the database
mysql_select_db($database)
or die ("Could not select database because ".mysql_error());

// create table on database
$create = "create table $table (
id smallint(5) NOT NULL auto_increment,
username varchar(30) NOT NULL default '',
password varchar(32) NOT NULL default '',
fname varchar(30) NOT NULL default '',
lname varchar(30) NOT NULL default '',
email varchar(30) NOT NULL default '',
members smallint(1) NOT NULL default '0',
ADD admin smallint(1) NOT NULL default '0' ";
PRIMARY KEY (id)";
UNIQUE KEY username (username)
);";




mysql_query($create)
or die ("Could not create tables because ".mysql_error());
echo "Complete.";
?>

Rep given.

Thanks

Matt

[madchild24]

is this a tutorial member system?
if so wich one as then we may be able to help u?

[lMattz]

Well.....i was sent it and was told it was a good member system. So i have done the config etc etc... then i go to install it and it says that.

[madchild24]

my suggestion is to add the table manual as files uselly dont work correct

[Dan Williamson]

It looks like a MySQL error.

Have you checked the queries and tables etc in PHPMyAdmin?

- Dan