2. PHPRunner General questions
  3. List page only record cecked.
This topic is locked

List page only record cecked.

 		10/28/2008 9:34:23 AM
PHPRunner General questions
M
 maxcolo author

Hi,

I have one table with 4 field:

id_nome int

nome varchar

cognome varchar

status true or false (situation)
example:
max smith (status) true

Jane Cola (status) false
I want see only max smith and all record true.

I have one question. What is the code for to view in list page only the record when status is true?

Best regards

Massimo
J
 		Jane 10/28/2008

Massimo,
add where clause to the SQL query on the Edit SQL query tab for this purpose.

Here is a sample:

select id_nome,

nome,

cognome,

status

from TableName

where status=True
M
 		maxcolo author 10/28/2008

Thanks so many,

six an angel, and this forum is excellent together with phprunner.