0){
$times[0].=":";
}
else{
unset($times[0]);
}
$times[1].="'";
$times[2].=""";
return(@join("",$times));
}
if($pnum){
$con=pg_connect("dbname=jjazz3 user=pguser");
/* get program record */
$result=pg_exec($con,"
select
id
,navigator
,director
,selector
,total_time
from bb_onair_info
where prog_num='$pnum'
and lang=$lang
and category=$category
");
$prog_values=@pg_fetch_array($result,0);
/* get song records */
if($prog_values[id]){
$result=pg_exec($con,"
select os.song_order
,s.name as songname
,a.name as artistname
,a.e_name as e_artistname
,a.url
,os.song_time
,d.pic_2
,d.onsale
,d.id as discid
,d.code as disccode
from bb_onair_songs os
join song s on (os.song_id=s.id)
join disc d on (s.disc=d.id)
left join artist a on (d.artist=a.id)
where prog_id='".$prog_values[id]."'
order by os.song_order
");
$i=0;
while($song_values=@pg_fetch_array($result,$i)){
//$totaltime=add_time($song_values[song_time],$totaltime);
/*------ ジングル判定 ------*/
if(substr($song_values[disccode],0,4)!="JNSJ"){
$songnum++;
$numstr="$songnum.";
$jingle_flg=0;
}
else{
$jinglenum++;
$numstr="♪";
$jingle_flg=1;
}
if($song_values[url]){
$aboutartist="";
}
else{
$aboutartist="";
}
$song_table.="
![\"about](\"../img/aboutartist.gif\")
![\"](\"/img/spacer.gif\"){kind=spacer}
";
}
$song_table.="
![](\"../img/line.gif\")
![\"about](\"../img/aboutcd.gif\")