repeated assoc array

[fife]

how do you use a while loop 2 twice from one assoc array? eg

 

<tr>
    <td>1st favourite</td>
    <td><select name = 'fav_1'>"; while($Cat = mysql_fetch_assoc($rCat)) { echo " <option value='{$Cat['catID']}'>{$Cat['categorys']}</option>";}

echo "</td>
  </tr>
  <tr>
    <td>2nd favourite</td>
    <td><select name = 'fav_2'>"; while($Cat = mysql_fetch_assoc($rCat)) { echo " <option value='{$Cat['catID']}'>{$Cat['categorys']}</option>";}

echo "</td>
  </tr>

 

The first one works fine but the second is empty.

[PFMaBiSmAd]

If you need to repeat the <option></option> selections, why not just produce that part of your output in a php variable and then simply echo the contents of that variable every time you need it?

[fife]

I would but I need 5 separate entries from the same array entered into my database

[fife]

ok I have updated the query to look as follows but still nothing is displayed in the 2nd box.

 

  $qCat = "SELECT * FROM category"; 
$rCat = mysql_query($qCat);
$Cat = mysql_fetch_assoc($rCat);

<td>1st favourite</td>
    <td><select name = 'fav_1'>"; while($Cat) { echo " <option value='{$Cat['catID']}'>{$Cat['categorys']}</option>";}

echo " </select></td>
  </tr>
  <tr>
    <td>2nd favourite</td>
    <td><select name = 'fav_2'>"; while($Cat){ echo " <option value='{$Cat['catID']}'>{$Cat['categorys']}</option>";}

echo "</select></td>
  </tr>

[kenrbnsn]

Here's one way of doing it:

<?php
$tmp = array();
while($Cat = mysql_fetch_assoc($rCat)) {
    $tmp[] = " <option value='{$Cat['catID']}'>{$Cat['categorys']}</option>";
}
$options = implode("\n",$tmp);
?>

<tr>
    <td>1st favourite</td>
    <td><select name = 'fav_1'>" <?php echo $options; ?></td>
</tr>
<tr>
    <td>2nd favourite</td>
    <td><select name = 'fav_2'>" <?php echo $options; ?></td>
  </tr>

 

Ken