=CURDATE() ORDER BY date ASC limit 3";
$tulos = mysql_query($kysely);
$max = mysql_num_rows($tulos);
for ($i=0; $i<$max; $i++) {
$rivi = mysql_fetch_array($tulos, MYSQL_ASSOC);
$date = $rivi['date'];
$venue = $rivi['venue'];
$url = $rivi['url'];
$city = $rivi['city'];
$country = $rivi['country'];
$info = $rivi['info'];
if ($url != "" && $url != NULL && strlen($url)>3) {
if (substr($url, 0, 4) != "http") {
$url = "http://" . $url;
}
$venue = "" . $venue . "";
}
if ($date >= date("Y-m-d")) {
}
echo $date . ":
" . $venue;
echo " |
![](\"pics/pixel_line_grau.gif\"){kind=tracking}