$sqllist="";
$sqllist.="select * from album where ex = '1' and id = 'hankai' ";
$sqllist.="group by artnum order by date desc ";
$mqlist = mysql_query($sqllist,$conn);
while($rec = mysql_fetch_array($mqlist)){
$id = _hs($rec['id']);
$artnum=_hs($rec['artnum']);
$title=_hs($rec['title']);
$date=_hs($rec['date']);
$Odate = _hs($rec['Odate']);
$ex = _hs($rec['ex']);
$comnum=0;
$sql="";
$sql.="select * from comment where artnum = '$artnum' ";
$mql = mysql_query($sql,$conn);
while($rec3 = mysql_fetch_array($mql)){
$comnum++;
}
$name="";
$sqll="";
$sqll.="select * from profile where id = '$id' group by id";
$mqli = mysql_query($sqll,$conn);
if($rec2 = mysql_fetch_array($mqli)){
$name = $rec2['name'];
}
?>