MySQL & PHP Question

[freeflow]

How can I make the "if" statement do something if the mysql query finds a result?

$sql = 'SELECT * FROM `Domains` WHERE `status` LIKE \'%delete%\';

if ($sql == ???) {

Do something;

}

Thanks for your help.

 

[Tree]

<?php
$query = mysql_query('SELECT * FROM `Domains` WHERE `status` LIKE \'%delete%\'');
if (mysql_num_rows($query) > 0) {
	# Do something
}
?>

 

[psalzmann]

$query = mysql_query("
        SELECT * 
        FROM Domains 
        WHERE status LIKE '%delete%'
"); 
if (mysql_num_rows($query) > 0) 
{ 
         while ($res = mysql_fetch_array($query))
         {
              // $res['something']...
         }
}