Help, getting info from two mysql tables with one query

[ryandarin]

I think the code is fairly self explanatory, so i'll post that first.

$query = "SELECT id,description,Title,tutorialtext,category," . 
                 "DATE_FORMAT(timeadded, '%Y-%m-%d') as date " . 
                 "FROM tutorial ORDER BY timeadded DESC LIMIT $max_items";

$query2 = "SELECT Name, catid," .
    "From tutorial_cats"

    $result = mysql_query ($query);
    while ($row = mysql_fetch_assoc ($result))

Im probably missing something simple, but how do I combine query and query2 togther so that it gets both the things from tutorial, and from tutorial_cats?

 

Tell me if you need more info, or if im not making sense.

 

Thanks alot , Ryan.

[Barand]

$query = "SELECT t.id, t.description, t.Title, t.tutorialtext, t.category, c.Name 
            DATE_FORMAT(t.timeadded, '%Y-%m-%d') as date  
            FROM tutorial t
            INNER JOIN tutorial_cats c ON t.category = c.cat_id
            ORDER BY t.timeadded DESC 
            LIMIT $max_items";

[ryandarin]

Hmm, I added this, but then it gives me this error, its probably a stupid mistake by me, but this is the error.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/tutorialscript/index.php on line 21

 

[Barand]

What does

 

$result = mysql_query ($query) or die(mysql_error());

 

give?

[Barand]

nm, I forgot the comma at end of first line after c.Name

[ryandarin]

Heh, I think it was my mistake actually, I had one of the field names wrong .

 

Thanks alot for you help I really appreciate it.