note 109709 rejected from function.mysql-fetch-row by aharvey
| From: | aharvey@php.net | Date: | Tue, 14 Aug 2012 01:14:34 +0000 |
| Subject: | note 109709 rejected from function.mysql-fetch-row by aharvey | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-190055@lists.php.net to get a copy of this message | ||
Note Submitter: apoorvgaur dot srcm at gmail dot com
----
<title>Registration</title>
</head>
<body>
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("oas", $con);
$id = $_POST['reg_id'];
$dob = $_POST['day'].$_POST['month'].$_POST['year'];
$name = $_POST['reg_fname'].$_POST['reg_lname'];
$sql1 = mysql_query("SELECT* FROM it WHERE regid LIKE 'IT%'");
$a = mysql_fetch_array($row[]);
$sql2 = mysql_query("SELECT regid FROM hr WHERE regid LIKE 'HR_%'");
$b = mysql_fetch_row($sql2);
$sql3 = mysql_query("SELECT regid FROM marketing WHERE regid LIKE 'M_%'");
$c = mysql_fetch_row($sql3);
if($id==$a)
{
$sql="INSERT INTO IT (regid, name, contactno, dob, address, emailid, password)
VALUES
('$_POST[reg_id]','$name','$_POST[reg_cntct]','$dob','$_POST[reg_add]','$_POST[reg_email_id]','$_POST[reg_pwd]')";
echo $sql;
}
else if($id==$b)
{$sql="INSERT INTO HR (regid, name, contactno, dob, address, emailid, password)
VALUES
('$_POST[reg_id]','$name','$_POST[reg_cntct]','$dob','$_POST[reg_add]','$_POST[reg_email_id]','$_POST[reg_pwd]')";
echo $sql;
}
else if($id==$c)
{$sql="INSERT INTO marketing (regid, name, contactno, dob, address, emailid, password)
VALUES
('$_POST[reg_id]','$name','$_POST[reg_cntct]','$dob','$_POST[reg_add]','$_POST[reg_email_id]','$_POST[reg_pwd]')";
echo $sql;
}
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "THANK YOU FOR REGISTRATION";
mysql_close($con);
?>
</body>
</html>
i want to differenciate the users on the basis of their reg_id at the time of registration into
three tables namely IT HR and MARKETING......this is an office automation syatem project.
Kindly help me out. Youe suggestions are really valuable.