Parse error: syntax error, unexpected T_STRING
im new to php, but have done c# or and c+ programming so find php quite easy... but this error has got me .....
the code is:
<?php
mysql_connect('localhost', 'root', '');
if (!$con)
{
die('Could Not Connect: ' .mysql_error());
}
// create a database (auctions4us)
if (mysql_query('CREATE DATABASE auctions4us', $con));
{
echo 'Database Created';'
}
else
{
error 'Error creating database: ' .mysql_error();
}
// Create Table IN tblAuctionsItems
mysql_select_db('auction4us', $con);
$sql ='CREATE TABLE tblAuctions4us'
(
IID Integer NOT NULL auto_increment
AID Integer NOT NULL auto_increment
Name Text NOT NULL,
Description Text NOT NULL
MinPrice decimal(5,2) NOT NULL
Increment decimal(2,2) NOT NULL
)';
mysql_query($sql,$con);
// create table (Users)
mysql_select_db("tblAuctionsUsers"), $con);
$sql = "CREATE TABLE UserAcconts
(
UserName varchar(50) NOT NULL,
password varchar(50) NOT NULL,
FirstName text NOT NULL,
Surname text NOT NULL,
JoinDate date NOT NULL,
AddressNo Integer NOt Null,
AddressStreet text NOT NULL,
AddressStreet2 text NOT NULL,
Town text NOT NULL,
County text NOT NULL,
Country text NOT NULL,
Emailaddress varchar(50) NOT NULL,
Paypal varchar(50),
Google varchar(50),
)";
mysql_query($sql,$con);
// end users table
// create table (auction bids)
mysql_select_db("tblAuctionsBids"), $con);
$sql = "CREATE TABLE bid
(
BidNo integer NO NULL auto_increment,
IID integer NO NULL,
UID integer NO NULL,
WinPrice decimal(5,2) NO NULL,
MaxBid decimal(5,2) NO NULL,
)";
mysql_query($sql,$con);
// end table auction bids
// create table tblauctions
mysql_select_db("tblAuctionsBids"), $con);
$sql = "CREATE TABLE bid
(
i have tried lots of stuff, but to no avail, thanks for any help
