Can anyone out there think of a way that I can highlight a cell in the table view base on its content? I have a client who wants to easily see which records have certain values in a particular field. Sorting won't help, as the key values are pretty much random such that 03.1, 03.2 and 03.5 are all important values, but 03.3 and 03.4 are not.

My thought was to create a kind of "telltale" where I would have a table of the key values and have the field change color when it's value matches one in the table. It's a method I used to use a lot when I was programming in Access VB.

I've been fumbling around for a couple of days now trying to figure out how I might do that in PHP or javascript, but haven't come up with any ideas. I was hoping someone out there may have done this sort of thing before and could point me in the right direction or even suggest a better method of giving my client what he needs.

I'm using PHPMagic Pro 3 on an Apache 2 server with PHP 5.2 and MySQL 5. PHPMagic has been a huge help thus far, allowing me to create a very nice application very quickly, but now of course I have a lot of code that I'm not very familiar with. It makes customizing a bit harder.

I'm sure it can be done using a php query script that has logic built into the query. Maybe poke around in some php forums.

I realize now that I didn't finish my question properly. Twenty1 is quite right and I've found a couple of different possibilities, but I'm not sure how to integrate it into the code that PHPMagic creates. Where would I put something like that? I've been able to change the look of all of the cells in a given column by modifying the code in "mycode_templateTV.html", but I'm not sure if there's any way of adding any sort of branching statement there such as an "IF/ELSE". Is there a way, or is there somewhere else that would be better?

Best regards,
Carl

It would probably go in your generated tablename_dml.php file within the ->
function insert() section. What would the evaluation look like?

IF fieldname1 > 0 then ......

However the page display is controlled by styles that could be another option.

Did your get things worked out..

I think styles may be the way to go. For example if the field value is 1 default is blue. If value is 2 then background is red.

td.special { background-color:<? echo (value==1)?'blue':'red'; ?>; }

This would work in PHP for this cell after creating the style -

<td class="special">

Good luck

The styles route is the way I'm trying to go, but I have a problem that I don't really understand. I would have thought that changing the style should happen in tablename_templateTV.html, but some of the attributes seem to be controled by datalist.php so it doesn't look right. I haven't been able to take the time to go through the code and figure it out, so I'm stuck.

Thank you,
Carl

Did you edit the generated styes file to add your own style or edit the styles from within phpmagic.

I added it myself - as I understand it, phpmagic only allows you to edit the existing styles, but I would need a new style to apply to a single column or better yet individual cells.

Open the generated style.css and add your style. It's that simple....