combine two queries together

[runrunforest]

table listing(id,category)

table listing_photo(listing_id,path)

query for these two tables

"SELECT a.* 
	   , b.*
   FROM listing a 
   LEFT OUTER 
   JOIN listing_photo b 
     ON b.listing_id = a.id
  WHERE a.id = $id"

table dictionary(abbreviation, meaning)

query for this table

"SELECT * 
FROM dictionary
WHERE abbreviation LIKE 'a.category%' "

Can you help me combine these two queries ?

[poizn]

Give this a go

SELECT *
FROM dictionary
WHERE abbreviation LIKE (SELECT a.category
                                   FROM listing a
                                   WHERE a.id = $id)

[r937]

SELECT a.* 
     , b.*
     , d.*
  FROM listing AS a 
LEFT OUTER 
  JOIN listing_photo AS b 
    ON b.listing_id = a.id
LEFT OUTER
  JOIN dictionary AS d
    ON d.abbreviation LIKE CONCAT(a.category,'%')
 WHERE a.id = $id

[runrunforest]

Thank you very much but that didn't help.

The "%" needs to be in the query

This is the reply for poizn answer

[runrunforest]

if(isset($a)) 
{ 
	$a_select = ", d.meaning ";
	$a_query = " LEFT OUTER JOIN dictionary d ON d.abbr = a.cat";
}
else
{
	$a_select = '';
	$a_query = '';
}

"SELECT a.* 
	   , b.*
     {$a_select}
   FROM listing a 
   LEFT OUTER 
   JOIN listing_photo b 
     ON b.listing_id = a.id
	AND b.key =1
	{$a_query}
  WHERE a.id = $id"

I put the variable $a_query in the query like that, would that be correct ? As I have unexpected error executing that query.

[aguroyz]

try putting as...

sumthing like this FROM listing AS a ... JOIN listing_photo AS b..

not quite sure though...

or may be its the curly braces...

[runrunforest]

Yeah thanks for reply. Don't bother about other syntax, assuming everything works fine untill I put the variable $a_query in there.

[runrunforest]

SELECT a.* 
     , b.*
     , d.*
  FROM listing AS a 
LEFT OUTER 
  JOIN listing_photo AS b 
    ON b.listing_id = a.id
LEFT OUTER
  JOIN dictionary AS d
    ON d.abbreviation LIKE CONCAT(a.category,'%')
 WHERE a.id = $id

This is exactly what I want.

Your MYSQL skill is like Michael Jordan in basketball, Schumacher in F1.