[Resolved] Help with complex(to a noob) query

[badgoat]

Hi!

I have a table which has a variable, $date_string. It's a date column. I want to pull db entries where the date in the $date_string variable is equal to or greater than today's date. When I do the basic query:

$sqlquery = "SELECT id, diwtitle, date_string from mktime

I get all the db entries, so I know it works. But when I try to narrow it down to only give entries after today I get the ' Could not execute mysql query !' error. The query I tried was:

$sqlquery = "SELECT id, diwtitle, date_string from mktime WHERE $date_string >= CURDATE()";

I have also tried:

$sqlquery = "SELECT id, diwtitle, date_string from mktime WHERE date >= NOW()";

And the various combos of the above. Could someone show me where I am messing up please?

[devinemke]

i assume the table is called "mktime"?

SELECT id, diwtitle, date_string FROM mktime WHERE date_string >= CURDATE()

[badgoat]

Wow, that worked! I swear I tried that too.. I blame my 10 left thumbs. 😉

Thank you devinemke!