<?php
$sql="select r_date,sum(r_sum) from record group by r_date order by r_date desc";
$rows=@mysql_query($sql) or die("SQL12 error!");
while( $row=mysql_fetch_array($rows) )
{
$r_date=$row[0];
?>
<tr align="center">
<td><?php echo $r_date;?></td>
<?php
$abc="select b_id from bigname order by b_id desc";
$ccd=@mysql_query($abc) or die("SQL13 error!");
while( $rd=mysql_fetch_array($ccd) )
{
}
?>
<td><?php echo $row[1];?></td>
</tr>
<?php
}
unset($sql);
unset($row);
unset($rows);
?>系统会在报"sql13 error"错误...求如何修改..
$sql="select r_date,sum(r_sum) from record group by r_date order by r_date desc";
$rows=@mysql_query($sql) or die("SQL12 error!");
while( $row=mysql_fetch_array($rows) )
{
$r_date=$row[0];
?>
<tr align="center">
<td><?php echo $r_date;?></td>
<?php
$abc="select b_id from bigname order by b_id desc";
$ccd=@mysql_query($abc) or die("SQL13 error!");
while( $rd=mysql_fetch_array($ccd) )
{
}
?>
<td><?php echo $row[1];?></td>
</tr>
<?php
}
unset($sql);
unset($row);
unset($rows);
?>系统会在报"sql13 error"错误...求如何修改..
1 2009-06-10 1 14.50
2 2009-06-10 2 3.50
3 2009-06-10 1 14.00
4 2009-06-09 1 5.00
5 2009-06-09 2 17.00
6 2009-06-09 4 200.00
7 2009-06-08 1 14.00
8 2009-06-07 1 8.00
9 2009-06-07 3 20.30
10 2009-06-07 1 5.50bignameb_id b_name
1 a
2 b
3 c
4 d想实现下面的样子日期 a b c d
2009-06-10 28.5 3.5 0 0
2009-06-09 5 17 0 0
select b_id from bigname order by b_id desc 中间改成这个样子select b_id from bigname where b_date='$r_date' order by b_id desc也就不会报错..很奇怪..