parse error, unexpected T_VARIABLE - in

Hi
I have a "parse error, unexpected T_VARIABLE" in the following code
it is in line 43 that will be the line starting with $sno=$row['0'];
I have tryed different things like including { } in the beginning and the end of the string
and cant find the problem
can any body pleas help me out

<?php

if(mysql_affected_row()==1)
mysql_select_db("dbregistration"or die("Unable to select database";
$result=mysql_query("SELECT*from student WHERE sno='$sno'";
while($row=mysql_query(fetch_row($result))

$sno=$row['0'];
echo"your student number is:$sno";

?>


thanks

Put your code in a code PHP block (4th button from left here on top) here on the forum to make it readable. And always make use of braces - it is good programming practice!

The while row is not equal in brackets - 3 versus two - therefore the error. Also not ['0'] but [0].

Language: PHP
<?php
$result = mysql_query(" SELECT * from student WHERE sno=';$sno';");
if ($result) {
$row = mysql_fetch_row($result);
$sno=$row[0]; 
}
else {
echo "$sno not found!";
}
?>

Thanks Mac