Help with mysql query

[kobbe]

for ($i = 4; $i > 1; $i--) {
  $sql = "SELECT b_namn, b_moder FROM bsr_bilar WHERE id=$temp_m";
  $result = mysql_query ($sql);
  $myrow = mysql_fetch_array ($result);
  $rubrik[$i] = $myrow["b_namn"];
  $temp_m = $myrow["b_moder"];
}

I have this loop but I'm trying to shorten down the load-time of the script, can I do this loop with a single mysql query ?

I don't need the exact code, only some help on the way cause I never worked with more complicated mysql querys 😉

I don't know if you need more help than the snippet above to understand what I'm looking for, kinda hard to explain =)

Thx in advance 🙂
Regards

[Oersoep]

You can do a select query on multiple tables. You can also do it on the same table.

select
a.b_namn as grandma,
b.b_namn as mother,
c.b_namn as child
from
bsr_bilar as a,
bsr_bilar as b,
bsr_bilar as c
where
c.id = b.moder and
b.id = a.moder and
a.id = '$temp_m'

[kobbe]

Oersoep, thx alot =) I got it working ! Many thx =)

Regards