Re: Pulling Certain Data
| From: | Daniel Clark | Date: | Tue, 06 Apr 2004 20:13:23 +0000 |
| Subject: | Re: Pulling Certain Data | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-182540@lists.php.net to get a copy of this message | ||
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.