php - Smarty foreach mysql 问题

Question

smarty 中的 foreach 遇到一些问题。

php

$rows4 = array(); 
   $result4 = mysql_query("SELECT * FROM stats_follow ORDER BY id DESC LIMIT 5"); 
   while($row4 = mysql_fetch_assoc($result4)) { 
   $rows4[] = $row4; 
    } 

   $rows45 = array(); 
   $result45 = mysql_query("SELECT * FROM stats_follow ORDER BY id DESC LIMIT 5 OFFSET 1"); 
   while($row45 = mysql_fetch_assoc($result45)) { 
   $rows45[] = $row45; 
    } 

/** assign variable */ 

$smarty->assign('rows4', $rows4); 
$smarty->assign('rows45', $rows45); 

tpl

{foreach $rows4 as $row4} 
    <tr> 
       <td><center>{$row4.datum|truncate:10:""}</center></td> 
       <td><center>{$row4.count|truncate:10:""} {$row45.count}</center></td> 
     </tr> 
      {/foreach}

但是我现在如何在这个 foreach 中分配第二个查询，这不起作用:

{foreach $rows4 as $row4 || $rows45 as $row45} 
    <tr> 
       <td><center>{$row4.datum|truncate:10:""}</center></td> 
       <td><center>{$row4.count|truncate:10:""} {$row45.count}</center></td> 
     </tr> 
      {/foreach}

Answer 1

试试这个:

$rows445 = array();
$result4 = mysql_query("SELECT * FROM stats_follow ORDER BY id DESC LIMIT 5");
while ($row4 = mysql_fetch_assoc($result4)) {
    $rows445[]['row4'] = $row4;
}

$result45 = mysql_query("SELECT * FROM stats_follow ORDER BY id DESC LIMIT 5 OFFSET 1");
while ($row45 = mysql_fetch_assoc($result45)) {
    $rows445[]['row45'] = $row45;
}

/** assign variable */    
$smarty - > assign('rows445', $rows445);