Using query results more then once?

The_Walrus

I am having trouble using my queries in for loops more then once, for instance.

$query = "select title, author from books";
$result = mysql_db_query($db,$query,$connection);
$records = mysql_num_rows($result);
$row = mysql_fetch_row($result);

this for loop works:

<tr>
<?
for ($a=0; $a<$records; $a++)
{
$row = mysql_fetch_array($result);
echo "<td>".$row[0]."</td>";
}

?>
</tr>

But when I try this loop right after it, it does not work, all the cells are empty, but it is the correct number...

<tr>
<?
for ($a=0; $a<$records; $a++)
{
$row = mysql_fetch_array($result);
echo "<td>".$row[1]."</td>";
}

?>
</tr>

this code will print a row with all the titles
then a row with blanks

I can swith the array row[0] and row[1] and it will print a row of authors then a row of blanks, so I know it is getting the data,

what I have been doing as a work around is running the query again with a different variable, like $row, $row2, $row3, etc....what the heck am I doing wrong?

leatherback

Hi,

Is there a reason why you do not get all the results in one "while" loop?

You can of course put all your data in a temp var while in the while loop!?

The_Walrus

I need to format the data in 3 rows of a table, the example i gave was just an example and the problem I was having, I need each row to be all the values of the different fields for each record selected, however the number of records selected are always different, sometimes 9 sometimes, 5 sometimes 12, etc.....example

row 1 would be authors
row 2 would be dates
row 3 would be titles

so when i do my for loop
<?
for ($a=0; $a<$records; $a++)
{
$row = mysql_fetch_array($result);
echo "<td>".$row[0]."</td>";
}

I cant switch rows until after it completes? I guess I really cant explain it , but im having trouble getting the the rows to display correctly any other way then 3 for loops seperated by <TR>??

leatherback

Try something along the line of:

$query = "Select * from books";

$Results = mysql_query($query)
    or die ("<b>Couldn't execute books query</b>");

while ($row =@ mysql_fetch_array($Results)) 
  {
   $body .="<tr><td>author:</td><td>$row[author]</td></tr>
<tr><td>Date:</td><td>$row[date]</td></tr><tr><td>Title:</td><td>$row[title]</td></tr>";      

	}

Or:

while ($row =@ mysql_fetch_array($Results)) 
  {
   $bodyrow1 .="<td>author:</td><td>$row[author]</td>";
   $bodyrow2 .="<td>Date:</td><td>$row[date}</td>
   $bodyrow3 .="<td>Title:</td><td>$row[title]</td>";      

   }

Does that help?

The_Walrus

that did what i was trynig to do, and will certianly help for a few other things ive been trying to do too. in case you were wondering I went with option 2, that one was very easy for me to follow, option 1 still seemed like it was going to make the rows after 1 title 1 auther 1 date, but option 2 does all titles new row, etc, which is inded what I needed to do...

Thanks again.

nnichols

You could also use "mysql_data_seek($conn, 0)" to reset the internal row pointer to the first row.