请教关于数字大小的判断
数据库warehouse
字段有 in_num out_num
用户入库的时候将入库量写入in_num,出库量则写入out_num 实现目标:当出库量大于库存量(in_num)的时候,做出拒绝操作的提示,以下是出库页面的代码,调试不出结果,不管出库量多大多小,都提示“无足够库存”,不解,也不知道我的代码写得对不对,特来请教各位大大们!if ($_POST["ac"] == 'out') {
$out_num = $_POST["out_num"];
$sid = $_POST["sid"]; $result = mysql_query("SELECT in_num FROM warehouse WHERE id=$sid'");
if ($in_num < out_num) {
echo "<script language='javascript'>";
echo "alert('无足够库存!');";
echo "</script>";
}
else{
$sql = "update warehouse set in_num=in_num-'$out_num',out_num='$out_num',path='$path',sid='$sid' where id=$sid";
mysql_query($sql);
mysql_close($conn);
echo "<script language='javascript'>";
echo "alert('出库成功!');";
echo " location='warehouse.php';";
echo "</script>";
}
}
数据库warehouse
字段有 in_num out_num
用户入库的时候将入库量写入in_num,出库量则写入out_num 实现目标:当出库量大于库存量(in_num)的时候,做出拒绝操作的提示,以下是出库页面的代码,调试不出结果,不管出库量多大多小,都提示“无足够库存”,不解,也不知道我的代码写得对不对,特来请教各位大大们!if ($_POST["ac"] == 'out') {
$out_num = $_POST["out_num"];
$sid = $_POST["sid"]; $result = mysql_query("SELECT in_num FROM warehouse WHERE id=$sid'");
if ($in_num < out_num) {
echo "<script language='javascript'>";
echo "alert('无足够库存!');";
echo "</script>";
}
else{
$sql = "update warehouse set in_num=in_num-'$out_num',out_num='$out_num',path='$path',sid='$sid' where id=$sid";
mysql_query($sql);
mysql_close($conn);
echo "<script language='javascript'>";
echo "alert('出库成功!');";
echo " location='warehouse.php';";
echo "</script>";
}
}
"SELECT in_num FROM warehouse WHERE id=$sid'"$in_num < out_num
$out_num = $_POST["out_num"];
$sid = $_POST["sid"]; $result = mysql_query("SELECT in_num FROM warehouse WHERE id=$sid");
if ($in_num < $out_num) {
echo "<script language='javascript'>";
echo "alert('无足够库存!');";
echo "</script>";
}
else{
$sql = "update warehouse set in_num=in_num-'$out_num',out_num='$out_num',path='$path',sid='$sid' where id=$sid";
mysql_query($sql);
mysql_close($conn);
echo "<script language='javascript'>";
echo "alert('出库成功!');";
echo " location='warehouse.php';";
echo "</script>";
}
}
$row = mysql_fetch_array($rustle);
$in_num = $row['in_num'];
$out_num = $_POST["out_num"];
$sid = $_POST["sid"]; $result = mysql_query("SELECT i_number FROM bj_base WHERE id=$sid");
$row = mysql_fetch_array($result);
$in_num = $row['in_num'];
if ($in_num < $out_num) {
echo "<script language='javascript'>";
echo "alert('无足够库存!');";
echo "</script>";
}
else{
$sql = "update warehouse set in_num=in_num-'$out_num',out_num='$out_num',path='$path',sid='$sid' where id=$sid";
mysql_query($sql);
mysql_close($conn);
echo "<script language='javascript'>";
echo "alert('出库成功!');";
echo " location='warehouse.php';";
echo "</script>";
}
}