Mysql duplicate item?

dreams4000

Hey all,

I have two entries in a database where they are tracking a member that is in two different projects. I want to make it so that the mysql call only pulls entries when the person is not in a certain project. So for example I have a ton of entries and two of them are Joe is in project 18 and joe is in project 14. I want to pull anyone in the call that isnt also in 18. I wouldn't want Joe to be called at all for either of those entries then, but would want someone to show up that was only in project 14. Any way to do this? My current call is below, I know its wrong=p but could use some advice. Thanks!

$tmpquery = "WHERE tea.project = '$id' AND tea.project != 18 AND (mem.profil = '2' OR mem.profil = '11' OR mem.profil = '12' OR mem.profil = '13') ORDER BY $block10->sortingValue";

rachel2004

Are the projects stored as columns in one table along with a column for employee names?

For example:

TABLE1
id,
firstName,
lastName,
project13,
project14,
project15,
project16
...
proejct18,
etc.

I could help you write the query if I knew a bit more about your table structure(s). Post again.

dreams4000

It is setup like this:
ID Project Id User ID (Some other stuff)
167 18 42 1 0 2
163 14 42 1 0 3
165 14 43 1 0 3

I would like the call to say, ok user 42 is in 14 and 18, so dont pull him... but user 43 is in only 14 so pull him. 18 is the one I want to limit on. The 14 could be any other project id.

Thanks for the help!

rachel2004

Will this work for you?

<?php
$joeUserID = "10";

$sql = "SELECT t.id,
               t.project,
               t.projectID,
               t.user,
               t.userID
        FROM Tables AS t
        WHERE t.projectID = '14'
        OR t.projectID = '18'
        AND t.userID != '$joeUserID'";

?>

dreams4000

Well that would pull 14 or 18.. I want to exclude someone totally if they have 18 as one of their projects.. Thoughts?

rachel2004

Oh, okay. You're asking for a subquery, which isn't supported in the current stable release of MySQL.

You'll need to break this into separate queries, then, or use JOINs.