Try something like this. (assuming "POSITION" is your peoples status within the organization
$r1="SELECT * FROM $main_tbl WHERE position IN ('A', 'I', 'L') ORDER BY position"; > I would like to only show people who are active within our roster and > within > the database I have identified those people by putting a "A", "I" or "L" > depending on their status with our organization. I guess I am looking for > a > way for the code to see how that person is labeled and then put them in > the > proper roster. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php