空调器 |
$strQuery="select id,title ,post_time from titles where status='Y' and zhuanti_id=4 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title,$post_time)=$db->Record;
$show_time=substr($post_time,0,10);
echo "·$this_title [$show_time] ";
}?>
|
|
|
电视机 |
$strQuery="select id,title,post_time from titles where status='Y' and zhuanti_id=5 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title,$post_time)=$db->Record;
$show_time=substr($post_time,0,10);
echo "·$this_title [$show_time] ";
}?>
|
|
|
电冰箱 |
$strQuery="select id,title,post_time from titles where status='Y' and zhuanti_id=6 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title,$post_time)=$db->Record;
echo "·$this_title [$show_time] ";
}?>
|
|
|
小家电 |
$strQuery="select id,title,post_time from titles where status='Y' and zhuanti_id=8 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title,$post_time)=$db->Record;
echo "·$this_title [$show_time] ";
}?>
|
|
|
洗衣机 |
$strQuery="select id,title from titles where status='Y' and zhuanti_id=7 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title)=$db->Record;
echo "·$this_title [$show_time] ";
}?>
|
|
|
厨卫设备 |
$strQuery="select id,title from titles where status='Y' and zhuanti_id=9 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title)=$db->Record;
echo "·$this_title [$show_time] ";
}?>
|
|
|
影音器材 |
$strQuery="select id,title from titles where status='Y' and zhuanti_id=10 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title)=$db->Record;
echo "·$this_title [$show_time] ";
}?>
|
|
|
电脑与通讯 |
$strQuery="select id,title from titles where status='Y' and zhuanti_id=11 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title)=$db->Record;
echo "·$this_title [$show_time] ";
}?>
|
|
|
零部件 |
$strQuery="select id,title from titles where status='Y' and zhuanti_id=12 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title)=$db->Record;
echo "·$this_title [$show_time] ";
}?>
|
|
|
其他产品 |
$strQuery="select id,title from titles where status='Y' and zhuanti_id=92 order by titles.id desc limit 0,10";
$db->query($strQuery);
while ($db->next_record()){
list($this_id,$this_title)=$db->Record;
echo "·$this_title [$show_time] ";
}?>
|
|
|
|