[ILUG] php

[Kae Verens]

Nils Olofsson wrote:

><? php
>$id1=$HTTP_GET_VARS['id'];//global vars are turned off.
>//query
>        $query="SELECT * FROM news_posts WHERE id=$id1";
>        $result=mysql_query($query) or die (mysql_error());
>
>while($row = mysql_fetch_array($result)){ 
>echo $row['title'];
>echo $row['news'];
>}
>
>I took out the html formating as its not important.
>There are about 5 records in the table but what happens is that
>it goes through the while loop  spitting out everything  
>as if i saild "select * FROM news_posts"
>if i change to variables to query1,result1 in page two it only show 
>what i asked for.
>  
>

I know this doesn't explain the anomaly, but why are you using a loop to 
display what should be just one result?

The above could be done easily as:
<?
$query='select * from news_posts where id="'.$_GET['id'].'"';
$result=mysql_query($query);
$row=mysql_fetch_array($result);
echo htmlspecialchars($row['title']).'<br />';
echo htmlspecialchars($row['news']);
?>

Kae