[AndrewD]

Originally Posted by Langly

Is there any way to add this into LDM? I've been trying to make a sig out of this but can't for some reason. I just keep getting table errors.

I think you'll need sql looking like this. Let us know how it goes.

PHP Code:

//get total LDM downloads downloaded
$queryd="SELECT COUNT(*) AS downloaded FROM local_linksdownloads";  
$downloadeda = mysql_query_eval($queryd,$link);
$downloadedb = mysql_fetch_array($downloadeda);
$totaldownloadeds=number_format($downloadedb['downloaded']);
mysql_free_result($downloadeda);

//get total LDM links available
$querye="SELECT COUNT(*) AS download FROM local_linkslink";  
$downloada = mysql_query_eval($querye,$link);
$downloadb = mysql_fetch_array($downloada);
$totaldownloads=number_format($downloadb['download']);
mysql_free_result($downloada);

//get latest LDM download
$queryf= "SELECT linkname AS newdownload FROM local_linkslink ORDER BY linkdate DESC LIMIT 1"; 
$latestdownloada = mysql_query_eval($queryf,$link);
$latestdownloadb = mysql_fetch_array($latestdownloada);
$latestdownload= $latestdownloadb['newdownload'];
mysql_free_result($latestdownloada);