Newbie ???

[Anon]

Please Help...

I created a task script for my office. I would like to know how to make the "Closed" jobs non-viewable.

I know I can probably use WHERE statement, just don't know how to write properly.

The cell in the table is called "status". The options are: Open, In Work, Pending, Closed, and Canceled.

I want all status to be viewable and not to include the Closed or Canceled status.

SELECT *
FROM $table_name
ORDER BY priority
";

I would gratefully appreciate any help.

Thanks
:o) Ivan

[keith73]

$query = "SELECT * FROM table_name WHERE status != closed OR status != canceled";

I'm not 100% sure about the syntax of the OR clause, but something like that will work.

• Keith

[fitzbean]

SELECT *
FROM $table_name WHERE (status<>'Closed' AND status<>'Canceled')
ORDER BY priority

[Anon]

Thanks for everything!

:o) Ivan