添加数据库这里总是出问题
if($fun==3){ $row=mysql_fetch_array(mysql_query(select * from production order by prono desc limit 0, 30 )); $num=$row['prono']; $num++; $nums=$num*10+3; echo 添加编号为:$num 的商品: 商品名称:
关键字:
价格:
生产地:
库存量:
是否含糖:
是否包邮:
卡路里:
图片路径:
净含量:
分类:
; }
if($fun%10==3&&$fun!=3){ $num=$_get['fun'];$num=($num-3)/10; $itime=date(ymd); if(!empty($_post['iproname'])){ echo $itime; $result=insert into prodution(prono,proname,prokey,proprice,proplace,sumnum,sugar,fee,calorie,time,picture,proweight,protype) values ('$num','$_post[iproname]','$_post[iprokey]','$_post[iproprice]','$_post[iproplace]','$_post[isumnum]','$_post[isugar]','$_post[ifee]','$_post[icalorie]','$itime','$_post[ipicture]','$_post[iproweight]','$_post[iprotype]'); } if (!mysql_query($result,$corn)) echo 添加失败!!; else echo 添加成功!!; }
数据库:
回复讨论(解决方案) int型不要加 ' ' 字符型要加 ' ' 你好好查查吧
mysql_error 提供相关错误信息,你不去看,怪哪个?
$result=insert into prodution(prono,proname,prokey,proprice,proplace,sumnum,sugar,fee,calorie,time,picture,proweight,protype) values ('$num','$_post[iproname]','$_post[iprokey]','$_post[iproprice]','$_post[iproplace]','$_post[isumnum]','$_post[isugar]','$_post[ifee]','$_post[icalorie]','$itime','$_post[ipicture]','$_post[iproweight]','$_post[iprotype]');
echo $result;
输出sql放在mysql工具执行看看
或者
mysql_query($result,$corn) or die(mysql_error());
