PHP Returning multiple rows using NOT LIKE

VeSSer2

Hello all, i am trying to formulate a search pattern in a URL using multiple parameters. For instance, i have a table that has a field named "STATUS", in that "STATUS" field i have 3 values "Discover, Active, Cancelled. I want to generate a search string to say

"select * from DATABASE where table is NOT LIKE Discover and Active". So the result would return all Cancels.

Here is the PHP URL i have so far that works on one value..any clues on how to work with another?

circuit_orderslist.php?x_status_1=Cancelled&z_status_1=NOT+LIKE%2C%27%25%2C%25%27

bpat1434

You want to query the DB to get all rows that in the column "Status" the value is "Cancelled". That's this query:

SELECT *
FROM `table_name`
WHERE STATUS = 'Cancelled'

And each query would take a similar form. If you want to use your type of query, it would look something like:

SELECT *
FROM `table_name`
WHERE STATUS NOT LIKE 'Discover' AND STATUS NOT LIKE 'Active'

frost110

VeSSer2 wrote:
circuit_orderslist.php?x_status_1=Cancelled&z_status_1=NOT+LIKE%2C%27%25%2C%25%27

Why are you passing not like through the query string?

That does not make sense. Someone can easily manipulate that SQL statement and retrieve any data they want.

You should add that into the internal code with some if statements etc.

--FrosT