| Index
» Projects
» phpMyEdit
» Forum
» colorization |
 |
danvolkov
Joined: 02 Oct 2007
Posts: 7
Posted: 2007-11-26 13:35
Back to top
Reply with quote
|
hi guys,
In my table, I have a date field named "dbNextDelivery" which is stored in "YYYY-MM-DD" format.
In the list mode I want to highlight all dbNextDelivery dates which are overdue, i.e. those that are before today's date. I tried examples posted on other similar threads here, but none of them worked for me, either because of minor mistakes in syntax or for some other reasons... Maybe there is a specific PME setting that I need to "switch on" to be able to use ['sql|LF'] in $opts? I don't know..
Could someone please post here an actually working code for colorization of my dbNextDelivery field? Many thanks in advance!
Dan
Last edited by danvolkov on 2007-11-26 21:28, edited 2 times in total
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2007-11-26 13:41
Back to top
Reply with quote
|
sql|LF = "if(dbNextDelivery>now(),concat('<span style=\"red\">',dbNextDelivery,'</span>',dbNextDelivery)'
should work (but never tested)
|
danvolkov
Joined: 02 Oct 2007
Posts: 7
Posted: 2007-11-26 14:10
Back to top
Reply with quote
|
sorry, but the code above does not work.
guys, would anyone please post here a TESTED example. many thanks!
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
