DDL Count

[Chris2k]

hi

im tryna count and show sites ddl count, here is wot ihave

           if(isset($core->siteSQL) && isset($core->siteSURL) && $core->numRows != 1) { //if site url are ok and are in db and have downloads
           
               $sid = mysql_query("SELECT sid FROM wcddl_sites"); 
               
               $getnumddls = mysql_query("SELECT COUNT (title) AS 'number' FROM wcddl_downloads WHERE sid = '$sid'");
               $result = mysql_query($getnumddls) or die(mysql_error());

           
               $siteinfos .= '<b>Site Downloads:</b> '.$result.'';
                } 

im getting: Query was empty

any help.....

Chris2k Reviewed by Chris2k on 21st Nov 2011. DDL Count hi im tryna count and show sites ddl count, here is wot ihave if(isset($core->siteSQL) && isset($core->siteSURL) && $core->numRows != 1) { //if site url are ok and are in db and have downloads $sid = mysql_query("SELECT sid FROM wcddl_sites"); $getnumddls = mysql_query("SELECT COUNT (title) AS 'number' FROM wcddl_downloads WHERE sid = '$sid'"); $result = mysql_query($getnumddls) or die(mysql_error()); Rating: 5