Select

[corruption]

I'm trying to run an admin script where the users are validated by the administrator. I have a category for approved where the default is NULL.

The sql query is this

$sql = "SELECT * FROM brothers WHERE approved = 'NULL' ORDER BY lname ASC";

Then i create a form with those values, and allow the admin to appove the person or delete the record from the database.

[LordShryku]

Use WHERE approved IS NULL. Otherwise it's looking for a string value of 'NULL'.

[corruption]

that didn't work so i tried something different.

well i changed the database to put a default value of Disapproved for every user. So now i have the output there that i want.

Then after selecting those that i approve, i want to update for each user that it lists. This may be multiple records so i want to do it all at the same time. I'm not sure what type of loop to use? I want to update each record or delete each record if it is not an actual member. I will post the two sources since they are lengthy.

Source Codes