[Resolved] unexpected T_ENCAPSED_AND_WHITESPACE.... on line 3

nicknax

<?php 
//defining variables
$addname = $_GET['name'];

//database connection

$db = mysql_connect("localhost", dbusername, dbpass); 

//query
$sql = 'INSERT INTO `table_2` ( `playername` , `wins` , `draws` , `losses` , `deadline` , `points` , `division` ) VALUES ('$addname', '0', '0', '0', '0', '0', '0');'
$sql2 = 'DELETE FROM `table_1` WHERE `username` = '$addname';'
$result = mysql_query($sql, $sql2, $db);
$number = mysql_num_rows ($result);
?>

It's for a league game site i'm making. Couldn't find the problem. Didn't think it was anything to do with the database. Not sure tho.

Any help would be great 🙂

bradgrafelman

You've got unescaped single quotes in the VALUES () section. You need to escape those with a backslash, i.e.

VALUES (\'$addname\',

etc.

leatherback

line 3? THat is confucing..

Anyway..

Columnames in queries do not need quotes. Values can take quotes, but if these values are actual numbers, you do not need them.

I have never heard of placing slashes in a query, unless you are trying to insert the quotes itself.

halojoy

// maybe $dbusername, $dbpass
$db = mysql_connect("localhost", dbusername, dbpass);

nicknax

Parse error: parse error, unexpected T_VARIABLE on line 11

I get this now 🙁

edit: dbusername is the username of my database; dbpass is the password.

leatherback

try this:

$sql = "INSERT INTO table_2 ( playername , wins , draws , losses , deadline , points , division ) VALUES ('$addname', '0', '0', '0', '0', '0', '0')";

nicknax

nope, still get an error.

This is the code I've got now...

<?php 
$addname = $_GET['name']; 
$db = mysql_connect("localhost", mydbusername, mydbpass);
$sql = "INSERT INTO table_2 ( playername , wins , draws , losses , deadline , points , division ) VALUES ('$addname', '0', '0', '0', '0', '0', '0')";
$sql2 = "DELETE FROM `table_1` WHERE `username` = \'$addname\';" 
$result = mysql_query($sql, $sql2, $db); 
$number = mysql_num_rows ($result); 
?>

Parse error: parse error, unexpected T_VARIABLE on line 6 (removed the comments just to test they weren't the problem)

halojoy

Originally posted by halojoy

// maybe $dbusername, $dbpass
$db = mysql_connect("localhost", dbusername, dbpass);

// what i meant was, I usually put $ in front of my variables
// maybe I do not have to ??????

[/B]

leatherback

Originally posted by halojoy
// what i meant was, I usually put $ in front of my variables
// maybe I do not have to ??????

Nice spotted..

/me ==sleeping -> true

nicknax

still an error on line 6.

leatherback

Hm..

as far as I know, you can only evaluate 1 sql statement at a time. So you need to remove one query from the mysql_query();

nicknax

<?php 
$addname = $_GET['name']; 
?>
<?php 
if ($_GET['step'] = '1'); 
{ 
$db = mysql_connect("localhost", $dbuser, $dbpass);
$sql = "INSERT INTO table_2 ( playername , wins , draws , losses , deadline , points , division ) VALUES ('$addname', '0', '0', '0', '0', '0', '0')";
$result = mysql_query($sql, $db); 
$number = mysql_num_rows ($result); 
?>
<p> Username <b><?php echo "$addname"; ?></b> has been inserted into the league.</p> 
<p><a href='?name=<?php echo "$addname";?>&step=2'>Next</a></p>
<?php
elseif ($_GET['step'] = '2'); 
{
$db = mysql_connect("localhost", $dbuser, $dbpass);
$sql = "DELETE FROM `table_1` WHERE `username` = '$addname';" 
$result = mysql_query($sql, $db); 
$number = mysql_num_rows ($result); 
} 
else 
{ 
echo "error: the link you have followed is either out of date or you've typed the address wrong!" } ?>

Tidied it up a bit, now there's an else if error on line 15.

Parse error: parse error, unexpected T_ELSEIF on line 15

thorpe

what is missing from this line?

$sql = "DELETE FROM table_1 WHERE username = '$addname';"

parse erros are not something you should reaslly need help with. look at your code.

laserlight

Quick quiz:
What do the following statements do, and what's really wrong with them?

if ($_GET['step'] = '1');

elseif ($_GET['step'] = '2');

halojoy

elseif ($_GET['step'] = '2');

Shouldnt it be an }
somewhere before that elseif

thorpe

and this line;

elseif ($_GET['step'] = '2');

should be

elseif ($_GET['step'] == 2);

nicknax

yep, there should, but it makes no difference.

The step things allow me to run two commands. step1, adds to the real league. Step2, removes from waiting list.

Still that damn line 15 error 🙁

halojoy

Originally posted by laserlight
Quick quiz:
What do the following statements do, and what's really wrong with them?
if ($_GET['step'] = '1');
elseif ($_GET['step'] = '2');
[/B]

should be
if ($_GET['step'] == '1');
Two ==

halojoy

Originally posted by nicknax
yep, there should, but it makes no difference.

The step things allow me to run two commands. step1, adds to the real league. Step2, removes from waiting list.

Still that damn line 15 error 🙁

See my privious post:
you have left out a right bracket, before that elseif
}

}

nicknax

I now have code...

<?php 
$addname = $_GET['name']; 
?>
<?php 
if ($_GET['step'] == '1');
{ 
$db = mysql_connect("localhost", $dbuser, $dbpass);
$sql = "INSERT INTO table_2 ( playername , wins , draws , losses , deadline , points , division ) VALUES ('$addname', '0', '0', '0', '0', '0', '0')";
$result = mysql_query($sql,$db); 
$number = mysql_num_rows ($result); 
?>
<p> Username <b><?php echo "$addname"; ?></b> has been inserted into the league.</p> 
<p><a href='?name=<?php echo "$addname";?>&step=2'>Next</a></p>
<?php
} elseif ($_GET['step'] == '2'); 
{
$db = mysql_connect("localhost", $dbuser, $dbpass);
$sql = "DELETE FROM `table_1` WHERE `username` = '$addname';" 
$result = mysql_query($sql,$db); 
$number = mysql_num_rows ($result); 
} 
else 
{ 
echo "error: the link you have followed is either out of date or you've typed the address wrong!" } ?>

still got line 15 error.

Parse error: parse error, unexpected T_ELSEIF on line 15