thanks for your help -
for a particular project ID# (say, '123') i have to get all users from table 'users' AND IF a user, proj_id exists in table 'users_projects' (echo ' checked')...
what i guess i'd do is
SELECT * FROM 'users'...
while ($row = ...) {
echo "<checkbox"...
SELECT * from users_projects WHERE projid == '123'...
while ($row1 == ...) {
echo ' checked';
}
}
but i can tell that that's either just plain wrong or at least very obtuse...
if someone can decipher my intent could you possibly offer a more concise query that will get me ALL users AND tell me if the user, projid exists in users_projects, please?
thanks much
