mysql unable to call

dreams4000

Hi all,

I am trying to do a call but can't quite seem to get it correct. I have been messing with it for a while and it partially works but one section is not working. The call is:

	$tmpquery .= "WHERE (pro.status IN(0,1,2,3,4) AND pro.assigned_by = '$id') AND teams.member NOT IN($id) AND (pro.complete_date > (NOW() - INTERVAL 370 DAY) or pro.complete_date = 0) ORDER BY $block1->sortingValue";

the "AND teams.member NOT IN($id)" part is what doesn't seem to be working right. The current statement pulls all projects with a status in that list or assigned by $id just fine, but there is also a teams section and I dont want it pulling projects that this $id is a team member of, even if it was assigned by this $id. I guess in normal english it would be, pull all projects with these status options and the project was assigned by this id, but dont pull it if this id is also a team member. Any way to get that into mysql? Thanks so much!

mourisj

Hi,

Try to echo your query, instead of trying to execute it, just to see if you have the values in $id which you expect!

It happened to me that queries didn't work and simply printing the query showed some error in varaibles (strings not quoted, sometimes even missisng values from expired cookies, ...)

Regards,

JJ Mouris