Query Help!!!

[chevys]

I am trying to pull a scecific ID from a table so I did:

 

ORDER BY i.itmtype WHERE i.itmtype={$2} ASC");

 

Is this even close?

 

Original here:

 

$inv=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_userid={$userid} ORDER BY i.itmtype ASC");

 

Thanks,

[The Little Guy]

What is iv, i, and it?

 

you should use descriptive names...

[fenway]

Nothing wrong with short aliases... but please show us the actual query being sent to the server.

[premiso]

What is iv, i, and it?

 

you should use descriptive names...

 

FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it

 

Nothing wrong with short aliases...

 

As for the OP, not sure if this is what you were after:

 

$inv=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_userid={$userid} AND i.itmtype={$2} ORDER BY i.itmtype ASC");

 

I think that is what you were after. Just needed an AND statement.

 

EDIT:

You may have to change the variable $2 to be the actual variable, as $2 is an invalid variable name in PHP.