'if' problem...

[kurotenshi]

Could someone little help me...

I was trying to made script what echo's only rows if them date is today or later... But I'm nothing expert and I don't know how it should made.

There are my script::   [ pvm=date, paikka=place, nro=number, id, lisatiedot=more information, keikat=gigs ]
And that PVM type is date...

Code Select Expand

$query = "SELECT pvm, paikka, nro, lisatiedot FROM keikat ORDER BY pvm ASC";
if(!$r = mysql_query($query))
{
   die(mysql_error());
}

if(mysql_num_rows($r) == 0) // no enteries
{
     echo 'Ei keikkoja tiedossa';
}

while($row = mysql_fetch_array($r))
if(DATE(NOW) >= $row['pvm'])
{
     echo "<div class='keikka'><a href=\"keikat.php?id={$row['nro']}\"><b>{$row['pvm']}</b> {$row['paikka']}</a></div>";
}

I hope that someone understand what I mean And may help me little...

[[Unknown]]

$query = "
   SELECT pvm, paikka, nro, lisatiedot
   FROM keikat
   WHERE pvm >= NOW()
   ORDER BY pvm ASC";

If pvm is a date column.  If it's an int column holding a timestamp:

$query = "
   SELECT pvm, paikka, nro, lisatiedot
   FROM keikat
   WHERE pvm >= UNIX_TIMESTAMP()
   ORDER BY pvm ASC";

-[Unknown]

[kurotenshi]

Thank you very much [Unknow]!