将查询结果拆分为3个集群

Question

I need to separate the results of a query in 3 clusters: rows 1-3, rows 4-6, rows 7-9 and place them in variables return1, return2, return3 resp. How can I do that efficiently?

$numrows = mysql_num_rows($sResult1);

$return1 = '';
$return2 = '';
$return3 = '';
for ($i = 0; $i < $numrows; $i++) {
    $row1 = mysql_fetch_array($sResult1);   
    $return1 .= '<a title="' . $row1['resort'] . ' @ ' . $row1['lud'] . '" class="item" href="/review/' . $row1['resort_us'] . '/' . $row1['cam_id'] . '"><img class="item__image" id="c' . $row1['cam_id'] . '" src="/xs1/' . $row1['cam_id'] . '.jpg" alt="' . $row1['resort'] . '" /><h2 class="item__title">' . $row1['resort'] . '</h2></a>';
}               

echo $return1;

Answer 1

Maybe this could help in any way:

(updated - added function floor before intval)

$numrows = mysql_num_rows($sResult1);

$return[] = array();

$return[0] = $return[1] = $return[2] = '';

for ($i = 0; $i < $numrows; $i++)
{
$row1 = mysql_fetch_array($sResult1);   
$return[intval(floor($i/3))] .= '<a title="' . $row1['resort'] . ' @ ' . $row1['lud'] . '" class="item" href="/review/' . $row1['resort_us'] . '/' . $row1['cam_id'] . '"><img class="item__image" id="c' . $row1['cam_id'] . '" src="/xs1/' . $row1['cam_id'] . '.jpg" alt="' . $row1['resort'] . '" /><h2 class="item__title">' . $row1['resort'] . '</h2></a>';
}               

echo $return1;

Since mysql_ are deprecated and (from our experience) could be problematic, consider maybe (if possible) moving to something else like mysqli, pdo.