| |
|
|
|
$result=mysql_query ("SELECT DISTINCT (
addcountry_icd.country), addcountry_icd.link, MAX(STR_TO_DATE(news_icd.date, '%Y-%m-%d')) AS date FROM addcountry_icd, news_icd
WHERE news_icd.country = addcountry_icd.country
AND STR_TO_DATE(news_icd.date, '%Y-%m-%d') < '2008-09-30'
GROUP BY addcountry_icd.country");
$row=mysql_num_rows($result);
while ($row = mysql_fetch_array ($result)){ ?>
| |
echo $row['country'];?>
|
|
} ?>
|
|