I need to do something that would seem easy. I need to display an SQL query result in a CB Tab. I installed the sample plugin HELLOWOLD and I have tried studying other plugins...I suck.
Can someone tell me how I could modify the HELLOWORLD to include
a simple query and show the results? Or point me to a sample that I can study. Thanks
$sql = "SELECT COUNT(*)
FROM geocaches, logvisit \n".
"WHERE geocaches.cache_id = logvisit.cache_id AND
logvisit.log_owner_id=".$id." AND
geocaches.cache_type = 'Traditional' AND
logvisit.log_type='Found'";
$rsql = mysql_query($sql) or die(mysql_error());
$count = mysql_result($rsql, 0, 0);
echo " <font face='verdana' size='2'><strong><br>
Traditional :".$count."<br>
</strong></font>
