[請益] 請問輸入資料之前的條件查詢要放在哪呢?!

[idcomputer (大順)]

<?php require_once('Connections/data.php'); ?>

------以下是DREAMWEAVER露露長的插入紀錄的CODE---------------------

我相信大家應該不會想看!!!!XD



----------DREAMWEAVER露露長的插入紀錄的CODE結束分隔線-----------





-----以下這段條件查詢該安排在哪一個段落呢----
希望在插入紀錄之前如果有重複，就不允許插入紀錄

mysql_select_db($database_data, $data);
$company = $row_Recordset1['name'];
$date2 = $row_Recordset1['date2'];
$query_Recordset2 = sprintf
("SELECT company,date2 FROM student WHERE company='%s' and date2='%s'",
$company , $date2);

$Recordset2 = mysql_query($query_Recordset2, $data) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
if ($totalRows_Recordset2>0){

echo "重複報名!!!!" ;

exit ;

}


--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 140.136.128.10
推 showsky:當然是先檢查看有沒有重複才能報名
推 yanli2:放在insert into 之前