Exluding empty resultsets

[julian1]

Hello there,

I have written a bit of code that counts all my resultsets, including those where there are only empty ones. How can I get it to count only the populated ones?

Here's the bit of code in question:

$query = "SELECT message FROM lobbymessage ORDER BY created";
$myresult = QueryIntoArray($query);
$result = count($myresult);
print "There are $result lobby messages.<p>";
for($i=0;$i<count($myresult);$i++){
print $myresult[$i]["message"];
}
?>
</BODY>
</HTML>
<p>

Could anyone out there help me out?

Cheers,

Julian

🙂

[leatherback]

How do you mean "populated?

You could add to your query something like:

where message <> ""

if that is what you are looking for.

[solodesignz]

$query = "SELECT message FROM lobbymessage where message is not null ORDER BY created";

Maybe..