Problem with selecting a date

[meeble3]

$result = mysql_query("SELECT DISTINCT area FROM pubs where location='VOP' (and renewal > 'CURRENT_DATE') order by county",$db);


The above query doesn't work.

What is wrong?

Thanks

James

 

[Olavxxx]

How does it not work?
Can you run other queries in that code?
eg. Are you sure the code is correct?

Also, why do you have the AND inside () ?

SELECT `area` FROM `pubs` WHERE `location` = 'VOP' AND CURDATE() + 0 <= `renewal` GROUP BY `area` ORDER BY `country` ASC;

ps. above code is not tested!

I would also recommend you reading up on time and date functions that mysql can offer you:

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

Good luck!

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[Olavxxx]

hmm,maybe this one is better:

... AND DATEDIFF(CURTIME() + 0, `yourfield`) >= 1 ...

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[meeble3]

Neither of these work I'm afraid...

 

[ericbrunson]

is 'renewal' a date field?

 

[Marker67]

not knowing the error your getting, could the issue be with the $db?

has it been set correctly? Do you even need it?