everything else.? if you do a SELECT *FROM database WHERE ID = ***
is there a way to SKIP certain records from being displayed that have specific information?
like for example, if someone classifies a record as "remove" is there a way to keep it from being displayed in a while statement when everything else is still displayed?
specifically this is what i mean...
the field name is "client_active" and in the FORM you can select "PPW", "Active", "Remove" etc...
then submit.
when it is submitted as Remove, i want it to go back to the main screen showing all records EXCEPT for the removed ones..
this is the code i have currently.
$result = mysql_query("SELECT * FROM whiteboard WHERE user_username = '".$contractor_login."' ORDER BY client_id DESC");
like i said.. field name is "client_active" and field info is "Remove"
what do i put in there to SKIP any "Remove" records.
NOTE: i don't want it to ACTUALLY REMOVE the records. ADMIN can see the records still ... don't worry about that though..
thanks in advance
is there a way to SKIP certain records from being displayed that have specific information?
like for example, if someone classifies a record as "remove" is there a way to keep it from being displayed in a while statement when everything else is still displayed?
specifically this is what i mean...
the field name is "client_active" and in the FORM you can select "PPW", "Active", "Remove" etc...
then submit.
when it is submitted as Remove, i want it to go back to the main screen showing all records EXCEPT for the removed ones..
this is the code i have currently.
$result = mysql_query("SELECT * FROM whiteboard WHERE user_username = '".$contractor_login."' ORDER BY client_id DESC");
like i said.. field name is "client_active" and field info is "Remove"
what do i put in there to SKIP any "Remove" records.
NOTE: i don't want it to ACTUALLY REMOVE the records. ADMIN can see the records still ... don't worry about that though..
thanks in advance