[RESOLVED] sum of 3 columns

v3nt

hey guys - i have a manual date system, a row each for year, month, day and i need to select entries below, above or inbetween the dates. I'm sure if i get help with one i'll be able to figure the othes out!

so todays date - 20060824 and joined date from table entry 20060430

how can i get it to join up the entered dates and see if thy are lower than todays' date?

$newsyear= date("Y");
$newsmonth = date("m");
$newsday = date("d");
$date_sum = "$newsyear$newsmonth$newsday";
$query = "SELECT * FROM exhibitions WHERE e_year.e_month.e_day <= $newsyear$newsmonth$newsday";

thanks in advance!

madwormer2

I think you want CONCAT()

http://mysql.com/doc/refman/5.0/en/string-functions.html

v3nt

$query = "SELECT * FROM exhibitions WHERE
concat(s_year, s_month, s_day) <= $newsyear$newsmonth$newsday AND
concat(e_year, e_month, e_day) >= $newsyear$newsmonth$newsday";

cheers for the hint!