List Value and SQL - Selecting all

[haribo83]

I have a list that passes values to an sql statement to show relevant results.

I have three options (All, Option One, Option Two) and cannot get the query to work.

If I choose option one or option two then the results are fine but I cannot find a way to display all results.

The code is below:

SELECT * from details WHERE otype = '$listoption'

[Phaelax]

SELECT * FROM details

Or, if for some reason you have to specify 'otype':

SELECT * FROM detail WHERE otype = '$listoptionA' OR otype = '$listoptionB'

[vibhaJ]

It might be some issue in query to passing 'Option Two'.
Also check database with having value 'Option Two'.

SELECT * from details

Without the option you just query the table name to retrieve all records. I am not sure what you are looking for?