inventory是库存 里边包括pic这个字段,现在要是先从inventory把图片选择出来,并插入record的pic中,但是插入之后图片的后缀名(jpg)没有了?如何解决??
下面这个是inventory这个表
部分代码如下,我试了下用字符串拼接,但是并没有什么卵用
$sql="select * from inventory where pid = '$pid'";
$sql2 = "update inventory set pnum = pnum-'$number' where pid = '$pid' ";
$query=mysql_query($sql);
$result = mysql_fetch_array($query);
@$pnum = $result['pnum'];
$price = $result['price'];
$price2 = $_POST["num"]*$price;
$suffix = ".jpg";
$pic = $result['pic'].$suffix;
if ($_POST["num"]!=""&&$_POST["num"]<=$pnum&&$_POST["num"]>0){
mysql_query($sql2);
$sql3 = "insert into record values('$uid','$pid','$number','$price2','$pic')";
mysql_query($sql3);
echo "";
echo "";
}else if (isset($_POST["num"])&&$_POST["num"]!=""&&$_POST["num"]>$pnum&&$_POST["num"]<=0){
echo "";
echo "";
}else{
echo "";
echo "";
}
查询如下