Simple Query Help

[BulldogGC]

How would I do something like this?

$ps2_genres = mysql_query("SELECT id FROM genres WHERE name LIKE 'PS2%'");
$ps2 = mysql_query("SELECT subject FROM news WHERE genreid IN (ALL THE RESULTS FROM THE QUERY PS2_GENRES)");

This is uber easy to do in CFM, VB.net, etc. but I can't seem to get it with PHP.

[Bunkermaster]

try a left join...

http://www.mysql.com

[BulldogGC]

Can you actually give any code examples though?

[kevinsequeira]

$query = "SELECT subject FROM news WHERE genreid IN (SELECT id FROM genres WHERE name LIKE 'PS2%')";

[Bunkermaster]

$sql ="
SELECT
     subject 
FROM 
     news
LEFT JOIN genres on 
     genres.id = subject.genreid
WHERE
     genres.name LIKE 'PS2%'";