[SOLVED] in php...

[Lamez]

I want to do this in PHP, so please do not hound me about posting in the wrong area

 

How do I do a IF statement if a row exist?

 

I want it to check if the row (in a table) exist and if it does delete it, and re add the new row, if it does not exist add the new row.

 

-Thanks!

[cooldude832]

if your criteria is going to meet one and only one row do

 

<?phph
$q = "Select count(*) as row_count from `Table` where this=that";
$r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
if(mysql_num_rows($r) >0){
    #The row exist
}
else{
   #The row of the given criteria is not there
}
?>

[Bauer418]

I understand you want to do it in PHP, however I think the MySQL syntax "REPLACE INTO" is what you're looking for.

[Lamez]

nope he has the right idea, thanks!