[jaishalg]

Hey all... i m facing a problem in while loop
anyone can help me plz. a little help will solve my problem

anyways i m doing this...
$first=mysql_query("select * from weeklymaster where nameofrsmzsm='$name'");
while ($row = mysql_fetch_object($first))
{
$nextid=$row->asmrsmid;
$nextid=$nextid;
echo("<br>Next ID ----".$nextid);
}
this is prints all the values of Next ID.but now i want those all values r in while loop out side the while loop. means...

$first=mysql_query("select * from weeklymaster where nameofrsmzsm='$name'");
while ($row = mysql_fetch_object($first))
{
$nextid=$row->asmrsmid;
$nextid=$nextid;
echo("<br>Next ID ----".$nextid);
}
echo("<br>Next ID ----".$nextid);

this is prints the last value of the nextid......


HOW CAN I GET ALL THE 4 VALUES WHICH WAS THERE IN WHILE LOOP OUTSIDE THE WHILE LOOP

HELP ME PLZ

[vek]

PHP Code:

$a_nextid = array();// create the array

$first = mysql_query("select * from weeklymaster where nameofrsmzsm='$name'");

while ($row = mysql_fetch_object($first))

{

   $nextid = $row->asmrsmid;

   $a_nextid[] = $nextid; // same as array_push($a_nextid, $nextid);

   echo('<br>Next ID ----'.$nextid);

}

// will print exactly the same thing as the while loop in order

foreach($a_nextid as $id)  // $id is the value that was pushed into the array

{

   echo('<br>Next ID ----'.$id); // use single quotes unless the string needs parsed.  could also do echo("<br>Next ID ----$id");

}