Error when using fetch_array

[bugmero]

Hi all ,

 

I have this code :

 

<?php

 

$dbuser="";

$dbpassword="";

$servername="";

$dbname="";

 

connecttodb($servername,$dbname,$dbusername,$dbpassword);

function connecttodb($servername,$dbname,$dbuser,$dbpassword)

{

global $link;

$link=mysql_connect ("$servername","$dbuser","$dbpassword");

if(!$link){die("Could not connect to MySQL");}

mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());

}

 

$query="select * from swr_player"

$rt=mysql_query($query);

echo mysql_error();

while($nt=mysql_fetch_array($rt)){

echo "$nt[FName] $nt[Lname] $nt[FB]<br>";   

}

 

 

?>

 

The data for connection is entered correctly . But i get this error messege :

 

Parse error: syntax error, unexpected T_VARIABLE in ................  line 18

 

Please help

 

Thanks

[JAY6390]

Missing a semicolon at the end of this line

$query = "select * from swr_player"

should be

$query = "select * from swr_player";

[bugmero]

Thanks for the help , that did it, so many details you have to watch for . 

[PFMaBiSmAd]

so many details you have to watch for

 

Actually, the syntax rules of any computer programming language are much simpler and consistent than the syntax rules of a written linguistic language, but you do need to proofread your code to make sure it has the correct syntax everywhere.