Append to MySQL SELECT?

[rockyracoon2]

I have a table of users and I am trying to grab 50 different rows. The users I grab are dynamic so I would like to loop through the sames and select them one at a time. The problem is, each pass I erase the previous SELECT. Is there a way to append to a previous select? Perhaps theres an easier way?

[Rayn]

$userDB = mysql_query("SELECT * FROM user");
if ($userInfo = mysql_fetch_array($userDB)) {
  do {
  } while ($userInfo = mysql_fetch_array($userDB));
}

Would work using only one select query.

[rockyracoon2]

amazing!