<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>徐州汽車網最新團購</title>
<style type="text/css">
body{margin: 0 auto; text-align:center; padding:0}
ul,li{margin:0; padding:0;list-style:none}
body,td,th {
font-size: 12px;
}
a:link {
color: #333333;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #333333;
}
a:hover {
text-decoration: none;
color: #FF3300;
}
a:active {
text-decoration: none;
}
img{border:0;}
/*Group buy*/
.groupbuy{ width:970px; border:1px solid #FEDDBA; padding:4px;}
.groupbuy ul{width:146px; border:1px solid #FEDDBA; padding:2px; height:180px; float:left; margin:0 4px;}
.groupbuy ul li{ text-align:center;}
.groupbuy ul li.realprice{ background:#333; background:url(../images/groupprice.jpg) no-repeat right top; height:40px; line-height:40px; font-family:"Microsoft YaHei",Arial;display:block; font-weight:bold;color:#fff;}
.groupbuy ul li.realprice img{ cursor:pointer;}
.groupbuy ul li.realprice span{float:left; margin:0; padding:0}
.groupbuy ul li.realprice span b{ font-size:18px;}
.groupbuy ul li.supprice{ text-align:center;}
.groupbuy ul li.supprice div table td{ background:#FDF4E3; text-align:center; }
</style>
</head>
<body>
<?php
error_reporting(0);
header("Content-type: text/html; charset=gbk");
$con = mysql_connect("localhost","mysql使用者名稱","mysql密碼");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// some code
mysql_select_db("tuanpcqc");
mysql_query("set names gbk");
$sql="select * from cenwor_tttuangou_product order by id desc limit 0,3";
$result = mysql_query($sql);
?>
<div class="groupbuy clear">
<?php
while($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$id=$row['id'];
$name = $row['name'];
$price = $row['price'];
$price=$row['price'];
$nowprice=$row['nowprice'];
$jiesheng=$price-$nowprice;
if ( $nowprice > 0 )
{
$discount = round(10 / ($price / $nowprice), 1);
}
else
{
$discount = 0;
}
if ( $discount <= 0 ) $discount = 0;
$pic=$row['img'];
$pic_arr=split(",",$pic);
$picadd=$pic_arr[0];
//echo $picadd;
$sql2="select * from cenwor_tttuangou_uploads where id=".intval($picadd);
$result2 = mysql_query($sql2);
$picurl = mysql_result($result2, 0,"url");
$picurl=str_replace("/demo/","/thumb/200x121/demo/",$picurl);
?>
<ul>
<li><a href="http://tuan.pcqc.com.cn/?view=<?=$id?>" target="_blank"><img alt="" src="<?=$picurl?>" width="120" height="90" /></a></li>
<li class="realprice"><span>￥<b><?=$nowprice?></b></span><a href="http://tuan.pcqc.com.cn/?view=<?=$id?>" target="_blank"><img alt="buy" src="images/buy.gif"/></a></li>
<li class="supprice">
<div>
<table>
<tr>
<td>原價</td>
<td>折扣</td>
<td>節省</td>
</tr>
<tr>
<td><?=$price?></td>
<td><?=$discount?>折</td>
<td>￥<?=$jiesheng?></td>
</tr>
</table>
</div>
</li>
</ul>
<?php
}
?>
</div>
<?php
function getpic($pic){
}
mysql_close($con);
?>
</body>
</html>
