pyp Code error

[zali44]

Hi everybody,

I am new to pyp. I am working on first php enabled database web page which is giving following error.

Parse error: syntax error, unexpected ';' in E:\inetpub\vhosts\snpet.org\httpdocs\php\index.php on line 34

It seems syntex error. I have consulted all onoline php help to trap error in following code.

$query="SELECT * from news";
$result=mysql_query($query);
#num = mysql_numrows(result);

mysql_close();

echo "<B> News Table data</b> <br>";

$i=0;

while($i < #num) {

$nheading = mysql_result($result,$i,"nheading"); (......line 34)
$ndetail = mysql_result($result,$i,"ndetail");
$ntype= mysql_result($result,$i,"ntype");
$ndate= mysql_result($result,$i,"ndate");
$uploadeddate= mysql_result($result,$i,"uploadeddate");

$i = $i+1;
}
echo "$i Rows listed.";
?>

Can anybody trap the error.

Regards,

[seandisanti]

Remove your mysql_close, that may fix it. additionally, this may be a slightly more readable way to do what you want...

Code: Select all

<?php
$query="SELECT * from news";
$result=mysql_query($query);
echo "<B> News Table data</b> <br>";
$i=0;
while($row=mysql_fetch_assoc($result)) {
   $nheading = $row['nheading'];
   $ndetail = $row['ndetail'];
   $ntype= $row['ntype'];
   $ndate= $row['ndate'];
   $uploadeddate= $row['uploadeddate'];
   $i++;
}
echo "$i Rows listed.";
?>

[tkdbb84]

its because you have

Code: Select all


while($i < #num) { 
$nheading = mysql_result($result,$i,"nheading");
....


# is the deprecated comment for PHP, so the interpreter sees:

Code: Select all

while($i
$nheading = mysql_result($result,$i,"nheading");


hence an invalid semicolon.