This topic is locked

Hide row based on cell value

9/25/2009 3:06:10 PM
PHPRunner General questions
B
bedri author

Hello.
I need to hide all my rows of my table_1, in which $Status_value == "Closed". And these rows after changing the $Status_value from "Open" or "Pending" to "Closed" from dropdownbox, to be shown in another table (ex: table_2) of my database, for later viewing;
Thanks in advice, I believe you can help me, just as previously, colorizing the rows based on content of $Status_value
HAVE NICE TIME.

mikue from germany 9/25/2009

Hi bedri,
use tiny modified sql statement for your purpose:
SELECT Field1, Field2, Field3, Status

FROM TABLE

WHERE Status !='Closed'

ORDER BY Any_Field
So after edit the open or pending records to status closed they won't be displayed anymore.
Then you can create own view for closed records only.
Regards Michael