How to write nested query???

[tuxbuddy]

I have written a query :

 

$result = mysql_query("SELECT incidents.id,incidents.description,users.firstname,users.surname,users.loginname from incidents,users where (incidents.owner_id = users.id) AND (incidents.contact_id = users.id) AND (' . ' select users.id from users where users.loginname='$myusername')"), $link);

 

I have doubt on the line:

(' . ' select 

.

 

Anyone who can help me with this??

[zenag]

i think it might be on this line 
where (incidents.ownerid = users.id)
it must be specified as tablename.users.id not like this...

[sasa]

try

$result = mysql_query("SELECT incidents.id,incidents.description,users.firstname,users.surname,users.loginname FROM incidents,users WHERE (incidents.owner_id = users.id) AND (incidents.contact_id = users.id) AND (users.loginname='$myusername')"), $link);