reuse mysql result?

[craftymind]

This is very stripped down but illustrates the idea

<?
$query = "SELECT * FROM stories";
$result = mysql_query($query);
echo "Titles:<br>";
while($titledata = mysql_fetch_array($result)){
	echo $titledata['title']."<br>";
}
echo "Content:<br>";
while($contentdata = mysql_fetch_array($result)){
	echo $contentdata['content']."<br>";
}
?>

Can you reuse a result or do you have to do a new query?

[cgraz]

the only way to know would be to try it. I personally haven't tried it, but give you should just give it a shot and see if it works. Another way to do this would be build an array of the content field in the first while loop then print it later on.

$query = "SELECT * FROM stories";
$result = mysql_query($query) or die(mysql_error());

echo "Titles:<br>";
   while($titledata = mysql_fetch_assoc($result)) {
      echo $titledata["title"] . "<br>";
      $contentdata[] = $titledata["content"];
   }

echo "Content:<br>";
   foreach($contentdata as $value) {
      echo $value . "<br>";
   }

Cgraz

[nnichols]

It won't work by just reaccessing the result resource without resetting the internal pointer -

<?
$query = "SELECT * FROM stories";
$result = mysql_query($query);
echo "Titles:<br>";
while($titledata = mysql_fetch_array($result)){
    echo $titledata['title']."<br>";
}

// reset internal pointer
mysql_data_seek($result, 0)

echo "Content:<br>";
while($contentdata = mysql_fetch_array($result)){
    echo $contentdata['content']."<br>";
}
?>

Hope this helps 😉

[craftymind]

Thanks nnichols, that was exactly what I needed.