Selecting 10 rows from a table and setting them each to a seperate variable?

[Link14716]

How exactly could I pull this off with just 1 query?

[Graphics]

LOL. What a conisidence. I'm asking more or less the same in my thread...

[Sebastian]

PHP Code:

<?php

$result = @mysql_query("SELECT * FROM $table");
        while ($row = mysql_fetch_row($result)) {

$var1 = $row[1];
$var2 = $row[2];
$var3 = $row[3];
$var4 = $row[4];
$var5 = $row[5];
$var6 = $row[6];
$var7 = $row[7];
$var8 = $row[8];
$var9 = $row[9];
$var10 = $row[10];

   }

?>

etc...

[Link14716]

Thanks

[Sebastian]

np. Thought i'd give another possibility.

PHP Code:

<?php

  $result = @mysql_query("SELECT id, date, topic, users FROM $table");
      while (list($id, $date, $topic, $users) = @mysql_fetch_row($result)) {

}

?>

etc..