mysql HELP!

[pk]

hi

How can i combine these 2 statements into one?

PHP Code:

select linkID from linkcat where cat='cars'; 


this will give me this
----------
|linkID|
|12 |
|1 |

PHP Code:

select title from links where linkID=12; 


will give me
----------
title
---------
|great cars|

can i combine those 2 statements? so that i will select all titles where cat='cars'?


I tried this

PHP Code:

select links.title from linkcat,links where linkcat.cat='cars'; 


but it didn't work. It just showed me all records

[JohnKelly]

Not sure of your table structure but based on what you wrote you might try something like the following ...

SELECT linkcat.linkID, links.title FROM linkcat, links WHERE linkcat.linkID = links.linkID AND linkcat.cat = 'cars';