Hi,
I have a dtabase with two tables in it.
AUTH
username
password
limit
grp1
grp2
grp3
grp4
grp5
grp6
grp7
ORDERFORM
chargeto
auth
This table has other fields but they are not important to the question
The query i am using at the moment is
SELECT `username`, `username` FROM `auth` " . " where " . "`limit` >= " . $_SESSION["total"] . " ORDER BY `username`"
This looks that the limit field on the AUTH table and only displays the usernames that have a limit high enough to sign.
The chargeto field is a dropdown list that shows a list of departments.
The grp fileds are going to be used for showing which department the user is in.
My question is this:
Can i change the query to look what is in the chargeto field and only display the users that have that department in one of thier 7 grp fields. It must keep its limit bit as well.
Any help will be appreciated
Adam