Join two tables

[yogourt]

Hello people.

I'm trying to build a dynamic gallery for my site.
No need to know how to output the images or something, my questions is basic. It important to understand how I want the catogories to be.

Basicly it's a question about joining two tables...

Here is the structure.

I got a main page with links to different categories of photography on my site. For example:

Nature
Macro
Portraits

etc..

Each of this link lead to a details page, which I made using Dreamweaver MX and Phakt2. ( details.php?recordID=3 ) details page takes more info for each category out of DB like : description, gallery name... and what I also wanted to add is a listing of gallery files for each category , which I take from another table...

So how do I join two or more tables so that I get a page that I want? I imagine it would require me to use a different query string, such as: details.php?recordID=3&galleryid=5
(if I wanted to take id 5 from my gallery table)

I hope I was clear enough.. 🙁

Are there any examples that I could use?

[stolzyboy]

there are a lot of examples here

http://www.mysql.com/doc/en/JOIN.html

[yogourt]

Thanx stolzyboy, but still I cannot find anything that works in my

Actualy here is my query that is generated by URL variable:

// begin Recordset
$KTParam1Recordset1 = '-1';
if (isset($HTTP_GET_VARS['recordID'])) {
$KTParam1Recordset1 = $HTTP_GET_VARS['recordID'];
}
$query_Recordset1 = sprintf("SELECT * FROM cat_db WHERE cat_id = %s " $KTParam1__Recordset1);
$Recordset1 = $mysql->SelectLimit($query_Recordset1) or die($mysql->ErrorMsg());
$totalRows_Recordset1 = $Recordset1->RecordCount();
// end Recordset

What should I add here to join another table to this recordset?