我想检查表中是否存在来自后$var
的值whch,如果存在,则在退出时给我消息。如果没有,则在表格中插入
$qry = "SELECT * FROM nl_lang_var where name='$var'";
$res =$GLOBALS['DB']->execute($qry);
if(mysql_num_rows($res)> 0)
{
echo "already existed";
exit;}
else {
$sql = "INSERT INTO nl_lang_var set value='$value' , name='$var' and langid=$langid"; }
用户在mysql Ref 中插入IGNORE
INSERT IGNORE INTO mytable
(primaryKey, field1, field2)
VALUES
('abc', 1, 2);