[PHP][MYSQL] Złożone zapytanie Opcje

[sebekzosw]

Witam :-)

Mam taki fragment kodu polegającym na dodaniu do tablicy newsów:

[PHP] pobierz, plaintext 
<?php
$result = mysql_query("SELECT * FROM news ORDER BY date DESC LIMIT 0,10");
while($row = mysql_fetch_array($result)) {
    $new['title'] = nl2br(stripslashes($row['title']));
      $new['content'] = nl2br(stripslashes($row['content']));
      $new['full_version'] = nl2br(stripslashes($row['full_version']));
      $new['date'] = $row['date'];
      $user = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE id='".$row['author']."'"));
      $new['author'] = stripslashes($user['login']);
      $news[] = $new;
}
?>
[PHP] pobierz, plaintext 

Jak zrobić to jednym zapytaniem (i pozbyć się tego

[PHP] pobierz, plaintext 
<?php
$user = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE id='".$row['author']."'"));
?>
[PHP] pobierz, plaintext 

(IMG:style_emoticons/default/questionmark.gif)