primary key

[blind487]

i put this in the newbie section... but it seems more fitting here (sorry)

this seems so obvious... i can't figure out why i can't figure it out.

this is obviously partial script

 
$count = 1; 

while ($count < 3) {           //this number will be equal to the number of news articles to show 

$sql = "SELECT * from news WHERE PRIMARY = $count";    

$r = mysql_db_query("news",$sql);  

$array = mysql_fetch_array($r);  

//code displaying $array

the code works fine... but i can't seem to SELECT * from tnews WHERE PRIMARY = ANYTHING. It doesn't work when i use even a known value if i change primary to any other variable and use a known value.. i'm fine. is there some easier way to get a row with a certain primary key that is defined???

thanks to ANYONE for the help

[drawmack]

don't double post