parse error unexpected $

Dev Articles Community Forums Sponsor:

May 28th, 2005, 06:41 PM

Beni_postal

Registered User

Join Date: May 2005

Posts: 3

Time spent in forums: 34 m 20 sec
Reputation Power: 0

parse error unexpected $

just started trying to make a registration script, pretty new to this so dont really know what im doing, any help would be apreaciated thanks. Keeps coming up with

Parse error: parse error, unexpected $ in XX/register.php on line 26

PHP Code:


		
			
 mysql_query("CREATE TABLE login_tbl(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
loginid VARCHAR(30), 
password VARCHAR(15),
email VARCHAR(60)")
or die(mysql_error());
$sql="INSERT INTO login_tbl (loginid, password and email) VALUES (".$loginid.",".$password.",".$email.")”;
$r = mysql_query($sql); 
 
if(!$r) {
 
$err=mysql_error();
 
print $err;
 
exit(); }
 
?>

May 28th, 2005, 06:57 PM

Madpawn

My beat is correct.

Join Date: Dec 2004

Posts: 339

Time spent in forums: 2 Days 22 h 3 m 33 sec
Reputation Power: 4

Which is line 26?

__________________
"A pawn is the most important piece on the chessboard -- to a pawn"

May 28th, 2005, 06:58 PM

Beni_postal

Registered User

Join Date: May 2005

Posts: 3

Time spent in forums: 34 m 20 sec
Reputation Power: 0

Quote:

Originally Posted by Madpawn

Which is line 26?

last line with the

PHP Code:

?>

May 28th, 2005, 07:02 PM

Madpawn

My beat is correct.

Join Date: Dec 2004

Posts: 339

Time spent in forums: 2 Days 22 h 3 m 33 sec
Reputation Power: 4

You've got some funny quotes closing your INSERT statement line that may be the problem -- try changing them to a normal ".

May 28th, 2005, 07:06 PM

Beni_postal

Registered User

Join Date: May 2005

Posts: 3

Time spent in forums: 34 m 20 sec
Reputation Power: 0

Thanks that helped alot..

is there any problems with the syntax aswell because that seems to be a problem now..
on line 6 being the

PHP Code:


		
			
 mysql_query("CREATE TABLE login_tbl(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
loginid VARCHAR(30), 
password VARCHAR(15),
email VARCHAR(60)")
or die(mysql_error());

and onwards

beni

May 28th, 2005, 07:10 PM

Madpawn

My beat is correct.

Join Date: Dec 2004

Posts: 339

Time spent in forums: 2 Days 22 h 3 m 33 sec
Reputation Power: 4

You're missing a closing parentheses at the end of your create statement.

You shouldn't have the create statement in there anyway, though -- you'll only be able to run the script once; you'll get a 'table already exists' error thereafter.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: