quick help with while loop

[aebstract]

I'm trying to get it to delete every row that has a certain number in a certain column, so I need to run a while for that number in that column, but there could be any number of them so I'm not sure exactly how to do it. Any help in a direction to go with this would be great.



edit: solved with:


[code]
} elseif ($action == deleteall){
$result = mysql_query("SELECT * FROM pmbox WHERE recieverid = '$id'");    
while($r=mysql_fetch_array($result))  {  
mysql_query("DELETE FROM pmbox WHERE recieverid = '$id'");             
}
}
[/code]

[redarrow]

why not do it this way.


database connection

select staement

while loop

if($the_colum > 0) {

delete

}

[AndyB]

[code]} elseif ($action == "deleteall") {
    mysql_query("DELETE * FROM pmbox WHERE recieverid = '$id'");            
} [/code]