[RESOLVED] mysql.....

[Beffic]

Yeah just working on a kick out of guild script. And ran into a mysql error...

Parse error: syntax error, unexpected T_STRING in C:\wamp\www\public_html\guild.php on line 257


 $Query="SELECT * from Users where ID='$Player'";
 $Query2=mysql_query($Query) or die("Could not get user stats");
 $User=mysql_fetch_array($Query2);
 $Guild1="SELECT * from Guilds where Name='$User[Guild]'";
 $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
 $Guild=mysql_fetch_array($Guild2);
 $Query="SELECT * from Users where Guild='$Guild[Name]'";
 $Query2=mysql_query($Query) or die("Could not get user stats");
 $topplayer3=mysql_fetch_array($Query2)
//line 257 mysql_query("UPDATE Users SET Guild='' WHERE ID='$topplayer3'");
 echo"Player kicked from your guild! <a href='guild.php'>Back</a>";

Now im stuckded

[bradgrafelman]

You're missing a semicolon at the end of line 256.

Also note that this error message has nothing to do with MySQL in any way; a parse error means the PHP interpreter couldn't understand the syntax of your script and was unable to compile it properly. There is a stickied thread located here dedicated to this type of error message as the culprit is usually one of only a few different coding errors.

[Beffic]

well wth.... i usually see these things =p thanks

[bradgrafelman]

By the way, you might want to learn about JOINs in SQL as it would make your script much more efficient; the three queries you use above could be rewritten as a single query.