| |
|
|
| ";
//--------------------------
$sql="select n_id,UNIX_TIMESTAMP(n_date) as my_date, n_recordcompany, n_year, n_person, n_bandtitle, n_album, n_year, reviewtext,pic_link,n_pic,n_file,n_newstype from review order by n_id desc $limit";
$result=@mysql_query($sql,$db);
$count=0;
while ($myrow=mysql_fetch_array($result))
{
if ($count % 3 == 0)
{
}
$n_id=$myrow["n_id"];
$n_date=date($date_format,$myrow["my_date"]);
$pic_link=$myrow["pic_link"];
$n_bandtitle=$myrow["n_bandtitle"];
$picture=$myrow["n_pic"];
$n_year=$myrow["n_year"];
$n_recordcompany=$myrow["n_recordcompany"];
$n_album=$myrow["n_album"];
$news_hold=explode("\n",$n_bandtitle);
for ($i=0;$i".$hold_word[$n]."";
}
else if (strpos($hold_word[$n],"@"))
{
$hold_word[$n]="$hold_word[$n]";
}
}
$news_hold[$i]=implode(" ",$hold_word);
}
$n_bandtitle=implode("\n",$news_hold);
$n_bandtitle=nl2br($n_bandtitle);
$hold = "";
if ($count % 3 == 0)
{
$hold.=" |
";
}
$hold.=$data;
$hold=str_replace("{start_date}",$n_date,$hold);
$hold=str_replace("{end_date}",$end_date,$hold);
$hold=str_replace("{n_newstype}",$n_newstype,$hold);
$hold=str_replace("{n_album}",$n_album,$hold);
$hold=str_replace("{news_number}",$n_id,$hold);
$hold=str_replace("{who}",$n_person,$hold);
$hold=str_replace("{year}",$n_year,$hold);
$hold=str_replace("{recordcompany}",$n_recordcompany,$hold);
$hold=str_replace("{n_bandtitle}",$n_bandtitle,$hold);
$hold=str_replace("{mini}",$abstract,$hold);
if ($picture)
{
$hold=str_replace("{picture}","![](\"imagefiles/".$picture."\")
",$hold);
// $hold=str_replace("{picture}","![\"".$n_bandtitle."](\"/inc/phpThumb/phpThumb.php?src=/review/imagefiles/".$picture."&w=100&h=100&zc=2\")
",$hold);
}
else
{
$hold=str_replace("{picture}","![](\"../images/nocover.png\")
",$hold);
}
echo $hold;
$count++;
}
echo "
";
?>
$num_rows)
{
$stop=$num_rows;
}
$start_point=$start+1;
$showing="