Another MySQL question

[eluser]Skulls[/eluser]

Code:

$try_this_sql=" SELECT * from projects WHERE ((project_client_id=$this->session->userdata('uid')) OR (project_contractor_id=$this->session->userdata('uid') ))
AND (project_creator_id !=$this->session->userdata('uid')) ";
$query=$this->db->query($try_this_sql);
$result=$query->result();

use the brackets to group conditions .. where (color=red or color=green) and (color!=black)