[Resolved] looping specific results

[SureFire]

I can't think of how to word this to search either this site or the manual.

I'm trying to display the results 5-10 of a table.

<?
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM members WHERE status='character' ORDER BY siteusername ASC";
$result=mysql_query($query);
$num=mysql_numrows($result); 
mysql_close();

$i=0;
while ($i < 5) {
$actor=mysql_result($result,$i,"siteusername");

?>

 <? echo "$actor" ?>


<?


++$i;
} 

?> 

That would be my first loop I would like a similar section of code that would display results 5-10 thanks for your help!

[paulnaj]

Hi SureFire,

Using mysql_result is not usually the best way ... 'while loops' are much more efficient, especiallly with large amounts of data.

Here's a couple of variations that might be more useful ...

<?php 
define('ITEMS_PER_PAGE', 5);


mysql_connect(localhost,$username,$password); 
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM members WHERE status='character' ORDER BY siteusername ASC"; 

echo '<h1>Method 1 - echo-ing straight to the browser</h1>';
$result = mysql_query($query);
$item = 0; 
while($row = mysql_fetch_array($result)){
	echo $row['siteusername'].'<br>';
	if($item == ITEMS_PER_PAGE - 1){
		$item = 0;
		echo '<hr>';
	} else {
		$item++;
	}
}

echo '<h1>Method 2 - storing results in an array and displaying later</h1>';
$result = mysql_query($query);
$item = 0; 
$page = 0; 
$actor = array();
while($row = mysql_fetch_array($result)){
	if(!isset($actor[$page])) $actor[$page] = array();
	$actor[$page][$item] = $row['siteusername'];
	if($item == ITEMS_PER_PAGE - 1){
		$page++;
		$item = 0;
	} else {
		$item++;
	}
}

echo '<hr>Actors<pre>';	
print_r($actor);	
echo '</pre><hr>';

mysql_close(); 
?>

Paul. 🙂

[SureFire]

I hope you know how much I appreciate your help. Taking the time to write that for me was very admirable..thanks a million!

[paulnaj]

Hey SureFire,

It's a pleasure!

Paul. 😉