[ILUG] php

[Kae Verens]

Nils Olofsson wrote:

>I using this php snipit to return a table entry that matches 10
>$query="SELECT title,news from news_post where id=10";
>$result=standard myslq connect stuff here.
>then I have 
>while($row=mysql_fetch_array($result){
>standard php stuff here
>}
>
>The id is an INT,but what i'm getting back is every record that is in the mysql table.
>running the query on the mysql console return only one entry so it can't be mysql.
>It seems that if i use differnet variables query1,query2 and so on each 
>page then it works and returns only what i ask for,I have even used
>mysql_free_result($result);
>mysql_close($link);
>at the end of each page to make sure that the database connection is
>closed,i've even put at the start of each page query=0; and query="";
>Global variables are turned off in the config so is there anything else
>i should be looking at?
>  
>

sounds like there's a typo somewhere. can you past the actual source 
(minus sensetive bits) ?

Kae