php version of ms movefirst

db96s1

i need to know the php version of the ms movefirst. i need to spin a recordset for html outputs that are in two different places on the web page. i am stuck on the second output not knowing how to 'movefirst' and spin again.

thanks in advance for your time and help.

db96s1

laserlight

What does "ms movefirst" do? I suspect that you are looking to reset the database result set pointer, but that depends on the database system that you use.

db96s1

I am currently using winXP, Apache 2.0, MySQl 5.0, PHP 5.0. sorry for not disclosing more sooner.

db96s1

Roger_Ramjet

Yes, .movefirst is RDO/ADO cursor control on ms. Equivalent in mysql/php is mysql data seek() .

Bye the bye. It may not be neccessary to run through the resultset twice, generally isn't. Just build the 2 html blocks as stings at the same time and then include those strings in the appropriate place.

db96s1

thanks Roger Ramjet

a code example is as good for me as a proton engergy pill is to you. :-)

db96s1

Roger_Ramjet

OK a quicky

$block1 = '<div id="list">';
$block2 = '<div id="details">';

while ($row=mysql_fetch_array($result)) {
   $block1 .= $row['col1'] . '<br />';
   $block2 .= $row['col2'] . ' ' . $row['col3'] . ' ' . $row['col4'] . '<br />';
}

$block1 .= '</div>';
$block2 .= '</div>';

echo '<body>';

include ('top.php');
include ('menu.php');

echo $block1;

echo '<div id="filler">'; 
// and any amount of other html
echo '</div>';

echo $block2;

include ('bottom.php');
echo '</body></html>';

As you see, you just assemble the html from the data before you use it.