这是我插入语句(靠!在google查询时“插入”被和谐了!)
$sql = mysql_query("INSERT INTO Student (netId, surname, forenames,cCode,cYear,dob,photo)
VALUES ('$netId', '$surname', '$forenames', '$cCode', '$cYear','$dob', '')");
if (mysql_query($sql,$con) )
{
echo "<script language=javascript>alert('Save data error!');history.back();</script>";
}
else {
echo "1 record added";
echo "<br/>";
echo "<table border='1'>";
echo "<tr>";
echo "<td>" . $netId . "</td>";
echo "<td>" . $surname . "</td>";
echo "<td>" . $forenames . "</td>";
echo "<td>" . $cCode . "</td>";
echo "<td>" . $cYear . "</td>";
echo "<td>" . $dob . "</td>";
echo "</tr>";
echo "</table>";
}
}
?>我在sql中那个photo我设置成null,这是否是返回false的原因呢?就是说我有个数据没插入!
$sql = mysql_query("INSERT INTO Student (netId, surname, forenames,cCode,cYear,dob,photo)
VALUES ('$netId', '$surname', '$forenames', '$cCode', '$cYear','$dob', '')");
if (mysql_query($sql,$con) )
{
echo "<script language=javascript>alert('Save data error!');history.back();</script>";
}
else {
echo "1 record added";
echo "<br/>";
echo "<table border='1'>";
echo "<tr>";
echo "<td>" . $netId . "</td>";
echo "<td>" . $surname . "</td>";
echo "<td>" . $forenames . "</td>";
echo "<td>" . $cCode . "</td>";
echo "<td>" . $cYear . "</td>";
echo "<td>" . $dob . "</td>";
echo "</tr>";
echo "</table>";
}
}
?>我在sql中那个photo我设置成null,这是否是返回false的原因呢?就是说我有个数据没插入!
你把php/mysql版本,完整的简化后的code(当然还要出现同样情况)贴出来大家试试
VALUES ($netId, '$surname', '$forenames', '$cCode', '$cYear','$dob', '')";
$row = mysql_query($sql);
if ($row)
{
echo "<script language=javascript>alert('Save data error!');history.back();</script>";
}如果再有错, 你就打也SQL语句, 直接到SQL下动行, 就知了