Determing $result is empty

[jstarkweather]

This is likely an easy one I'm sure, but my google searches are prooving fruitless and you guys are always helpful. 🙂

I need to know when a db query returns no data. The following is an example of where I am trying to apply the detection...

$query = "SELECT topic_id, forum_id, topic_title, topic_time FROM $table[board_topics] WHERE topic_poster='$posterid' ORDER BY topic_time DESC LIMIT 10";
$result = $dbconn->Execute($query);

HELP >>> if (Detect whether $result has data or no) {
echo "show text";
}

while (list($ttopic_id, $tforum_id, $ttopic_title, $ttopic_time) = $result->fields) {

$result->MoveNext();
.....

Thanks,
Jim

[dannys]

What DBLibrary are you using? - whatever it is, it should have a numrows function - using that would probably be your best bet.

[Moonglobe]

IE for mysql: if (!mysql_num_rows($res))...