Show text or image, based on data value


#1

Hi,

I have a table sales with the columns, title, short_description,
long_description, start_date, end_date. The columns start_date end
end_date has both a date value.

My sales record are show on a index-page, with the start_date and
end_date published.

I want on the index-page a “timer” based on end_date. By example today
it is 2 april and a sales availability end_date is 4 april, i want to
show to the consumer “You only have 2 days left” or a image(2.gif) with
text in the same context…

I am newbie…someone suggestions/links?

Grtz…remco


#2

Use date comparison functions (DATEDIFF, CURRENT_DATE) in your
database query.

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

On Apr 2, 11:39 am, Remco S. removed_email_address@domain.invalid