[PHP-users 27368] Re: 日付の処理について

[Atsushi Kojo]

artsです。お世話になります。

>   $sql = "select kamoku.kamokuname,gakuid,gakuname,sum(itp) from kamoku
> left join itps on kamoku.kid=itps.kid where sdate between sdate='$tmp_
> kdate' and  sdate='$tmp_sdate' group by itps.kid, gakuid,gakuname order
> by gakuid";

変数で渡すなら

$sql = "select kamoku.kamokuname,gakuid,gakuname,sum(itp) from kamoku
left join itps on kamoku.kid=itps.kid where sdate between '$tmp_kdate' and
'$tmp_sdate'
group by itps.kid, gakuid,gakuname order by gakuid";

じゃないんでしょうか？
でも20051001とかで渡すのもどうかと思いますよ。