How to refresh mysql_fetch_assoc() or reset?

[Lauj]

I want to display the result from the MySQL database query twice on the page. The first, I have this:

<?
$row_rsScholarshipDetails = mysql_fetch_assoc($rsScholarshipDetails);
	$category = $row_rsScholarshipDetails["category"];
         echo "Category: ".$category."<br>";
?>

Then further down the page I did this:

<?
$totalRows = mysql_num_rows($rsScholarshipDetails);
     if($totalRows > 0){
          while ($row_rsScholarshipDetails = mysql_fetch_assoc($rsScholarshipDetails)){
               $require1 = $row_rsScholarshipDetails["reqr1"];
               //then create my table and display my results from the query into a 
              //table
              }
          }
?>

Now, the problem is that the second display of result skips the first data in the database. If delete or didn't have the firest display then everything works out fine. So how do I prevent it from skipping the firest data in the datbase?

ljCharlie

[paulnaj]

Hi Charlie,

Probably the easiest way is to store the output in variables whilst running through the query and then display them later.

You could do something like ...

<? 
// (Sorry , I've shortened the variable names for display purposes)

// OK Suppose you've just run ...
// $rsSD = mysql_query('SELECT * FROM ...');

// Get the num rows straightaway (Why not?)
$totalRows = mysql_num_rows($rsSD); 

$category = '';
$table_rows = '';
while($row_rsSD = mysql_fetch_assoc($rsSD)){ 
	// Only true on first pass!
	if($category == '') $category = $row_rsSD['category'];

// Do whatever ...
$require1 = $row_rsSD["reqr1"]; 

// Build the table ... (I'm guessing here !!)
$table_rows .= '<tr><td>'.$row_rsSD['field1'].'</td><td>'.$row_rsSD['field2'].'</td></tr>';
} 

// In your example you assume that at least one row is returned
// because you call 'mysql_fetch_assoc' before checking $totalRows > 0
// So ....
echo 'Category: '.$category.'<br>'; 


// Later on down the page ...

// Only need to check $table_rows now
if($table_rows != ''){
	echo '<table border="1" cellpadding="2" cellspacing="0">'.$table_rows.'</table>';
}
?>

Hope that helps!

Paul 🙂