كود:
//if (isset($_REQUEST["btnSubmit"]))
{
// gather info...
$action = $_REQUEST["btnSubmit"];
$usrID = $_REQUEST["txtID"];
$result = mysql_query("select * from media where id = '$usrID'");
$row = mysql_fetch_array($result);
$usrEmail = strtolower($_REQUEST["txtEmail"]);
$usrName = $_REQUEST["txtName"];
$usrType = $_REQUEST["txtCat"];
$cat = $_REQUEST["txtCatID"];
$start = $_REQUEST["txtStart"];
//get the error message...
$errorCode = 0;
//check action
if ($action =="إضافة مشترك")
{
//check if user exist...
$strSQL1 = "select * from mlist where email='$usrEmail'";
$usrDate = date("Y-m-d");
$result = mysql_query($strSQL1);
if (mysql_num_rows($result))
$errorCode = 1; //user already exist
else
mysql_query("insert into mlist(email, name, type, date) values('$usrEmail', '$usrName', '$usrType', '$usrDate')");
}
else
{
$strSQL1 = "select * from mlist where email='$usrEmail' and id!='$usrID'";
$result = mysql_query($strSQL1);
if (mysql_num_rows($result))
$errorCode = 1; //user already exist
else
mysql_query("update mlist set name='$usrName', email='$usrEmail', type='$usrType' where id='$usrID'");
}
}
header ("Location: mlist.php?start=$start&cat=$cat&error=$errorCode");
?>