
Untitled
By: a guest on
Aug 10th, 2012 | syntax:
None | size: 0.67 KB | hits: 5 | expires: Never
PHP How to check if MySQL result contains value
$getfreq = mysql_query("SELECT wp_term_relationships.term_taxonomy_id FROM wp_term_relationships WHERE wp_term_relationships.object_id = '1737'");
if (in_array(569,$getfreq,TRUE) {
echo "Success!";
} else if (in_array(654,$getfreq,TRUE) {
echo "Not good";
} else {
echo "Failure";
}
print_r($getfreq);
$res = mysql_fetch_array($getfreq);
if (in_array(569,$res,TRUE) {....
while ( false !== ($row = mysql_fetch_assoc($getfreq))) {
// make your comparison for each row
}
while ($row = mysql_fetch_assoc($getfreq)) {
if ($row[term_taxonomy_id] == 345) {
echo "WORKS!";
}
}