Let's say you want to show results that do not have 0 downloads from a file database?
PHP Code:
$ObtainInfo = mysql_query("SELECT * FROM `MyFiles` WHERE `downloads` != '0' ");
turn this into an array and output as needed.
Otherwise you can use if statements and check each result individually before outputting;
PHP Code:
$ObtainInfo = mysql_query("SELECT * FROM `MyFiles`"); $Info = mysql_fetch_array($ObtainInfo);
if($Info['downloads'] != '0'){ echo $Info['title']; }
Of course you can adapt to be more than, less than etc using these techniques based on if you are more familiar with PHP or MySQL syntax's/
|