[SOLVED] Drop-down Displaying MySQL Data

[tpsilver10]

I've got this dropdown trying to call the data in...basically, I only want it to show if it is an upcoming event. Past events are hidden away in the archives.

 

I can get it to work if I remove the if ($row['date'] etc, but not with it in. Can anyone spot any errors with my code?

 

<?php
$query  = "SELECT description FROM events";
$result = mysql_query($query);
echo "<select name=\"events\">";
while($row = mysql_fetch_assoc($result)){
if ($row['date'] >= date('Y-m-d')){
	displayEvents($row);
	echo "<option name=\"description\" value=\"$row[description]\" class=\"formstyles\" />$row[description]</option>";
	}
} 
?>

[clown[NOR]]

it might be that you don't have any values in the database that's higher or equal to today's date...

[tpsilver10]

Haha...I'm not that silly dude 

[clown[NOR]]

hehe... gotta rule out everything

[clown[NOR]]

what is you add strtotime()??

 

if (strotime($row['date']) >= strtotime(date("Y-m-h)))

[tpsilver10]

Like this?

 

<?php
$query  = "SELECT description FROM events";
$result = mysql_query($query);
echo "<select name=\"events\">";
while($row = mysql_fetch_assoc($result)){
if (strotime($row['date']) >= strtotime(date("Y-m-h"))){
	displayEvents($row);
	echo "<option name=\"description\" value=\"$row[description]\" class=\"formstyles\" />$row[description]</option>";
	}
} 
?>

 

Cos that one didn't work...hmmm...

[clown[NOR]]

hmmm yeah that's what I ment... what If you try this

 

$query = "SELECT * FROM events";

[tpsilver10]

Nope no good on that one either. It's very strange...

[tpsilver10]

Got it!

 

<?php
$query  = "SELECT * FROM events ORDER BY date, time";
$result = mysql_query($query);
echo "<select name=\"events\">";
while($row = mysql_fetch_assoc($result)){
if ($row['date'] >= date('Y-m-d')){
	displayEvents($row);
	echo "<option name=\"description\" value=\"$row[description]\" class=\"formstyles\" />$row[description]</option>";
	}
} 
?>

 

Thanks for trying champ.

[clown[NOR]]

np...