Problem in Insert Into Code
Posted: Thu Jan 17, 2008 12:16 am
Error generated : "Error, insert query failed"
For the Following Code : -
<?Php
$mysql_user = "os2s";
$mysql_password = "online2";
$myDatabase = "online";
$server = "localhost:3306";
$Name=$_POST['Name'];
$Address=$_POST['Address'];
$City=$_POST['City'];
$Pcode=$_POST['Pcode'];
$State=$_POST['State'];
$Country=$_POST['Country'];
$Cperson=$_POST['Cperson'];
$Desig=$_POST['Desig'];
$Ophone=$_POST['Ophone'];
$Rphone=$_POST['Rphone'];
$Fax=$_POST['Fax'];
$Mobile=$_POST['Mobile'];
$Email=$_POST['Email'];
$Website=$_POST['Website'];
$Categ=$_POST['Categ'];
$AbServ=$_POST['AbServ'];
$Utype=$_POST['Utype'];
$Rtype=$_POST['Rtype'];
$Rmks=$_POST['Rmks'];
$con = mysql_connect($server,$mysql_user,$mysql_password);
@mysql_select_db($myDatabase, $con) or die("Unable to select database");
$query = "SELECT * FROM register WHERE Name = '$Name' AND Address = '$Address'";
$result = mysql_query($query, $con);
If (mysql_numrows($result))
{echo "<br><br><font color='#FF0000' size='2' face='Verdana, Arial, Helvetica, sans-serif'><b><center>You had registered yourself in previous occassion. Please don't do that again. To enter into the site you have to use your unique User Id and Password which had been supplied by us.</center></b></font><br><br>";
}
Else
{
$query = "INSERT INTO register (RegId, img_id, ScrapId, Name, Address, City, Pcode, State, Country, Cperson, Desig, Ophone,"
. "Rphone, Mobile, Fax, Email, Website, Categ, AbServ, Utype, Rtype, Uid, Pwd, Rmks) VALUES (, , , '$Name', '$Address',"
. " '$City', '$Pcode', '$Pcode', '$State', '$Country', '$Cperson', '$Desig', '$Ophone', '$Rphone', '$Mobile', '$Fax',"
. " '$Email', '$Website', '$Categ', '$AbServ', '$Utype', '$Rtype', '', '', '$Rmks')";
@mysql_query($query, $con) or die('Error, insert query failed');
echo "<font color='#0000FF' size='2' face='Verdana, Arial, Helvetica, sans-serif'><b>Dear <font color='#FF0000'>$Name</font>,<br><br>Now you are become a registerd member of Onlines2s.com. <br><br>Your User Id and Password will be sent to you shortly in your email address.</b></font><br><br>";
}
mysql_close($con);
?>
Pl let me know where the problem lies and its solution. Treat this as most urgent
thanks & regards
Subho
For the Following Code : -
<?Php
$mysql_user = "os2s";
$mysql_password = "online2";
$myDatabase = "online";
$server = "localhost:3306";
$Name=$_POST['Name'];
$Address=$_POST['Address'];
$City=$_POST['City'];
$Pcode=$_POST['Pcode'];
$State=$_POST['State'];
$Country=$_POST['Country'];
$Cperson=$_POST['Cperson'];
$Desig=$_POST['Desig'];
$Ophone=$_POST['Ophone'];
$Rphone=$_POST['Rphone'];
$Fax=$_POST['Fax'];
$Mobile=$_POST['Mobile'];
$Email=$_POST['Email'];
$Website=$_POST['Website'];
$Categ=$_POST['Categ'];
$AbServ=$_POST['AbServ'];
$Utype=$_POST['Utype'];
$Rtype=$_POST['Rtype'];
$Rmks=$_POST['Rmks'];
$con = mysql_connect($server,$mysql_user,$mysql_password);
@mysql_select_db($myDatabase, $con) or die("Unable to select database");
$query = "SELECT * FROM register WHERE Name = '$Name' AND Address = '$Address'";
$result = mysql_query($query, $con);
If (mysql_numrows($result))
{echo "<br><br><font color='#FF0000' size='2' face='Verdana, Arial, Helvetica, sans-serif'><b><center>You had registered yourself in previous occassion. Please don't do that again. To enter into the site you have to use your unique User Id and Password which had been supplied by us.</center></b></font><br><br>";
}
Else
{
$query = "INSERT INTO register (RegId, img_id, ScrapId, Name, Address, City, Pcode, State, Country, Cperson, Desig, Ophone,"
. "Rphone, Mobile, Fax, Email, Website, Categ, AbServ, Utype, Rtype, Uid, Pwd, Rmks) VALUES (, , , '$Name', '$Address',"
. " '$City', '$Pcode', '$Pcode', '$State', '$Country', '$Cperson', '$Desig', '$Ophone', '$Rphone', '$Mobile', '$Fax',"
. " '$Email', '$Website', '$Categ', '$AbServ', '$Utype', '$Rtype', '', '', '$Rmks')";
@mysql_query($query, $con) or die('Error, insert query failed');
echo "<font color='#0000FF' size='2' face='Verdana, Arial, Helvetica, sans-serif'><b>Dear <font color='#FF0000'>$Name</font>,<br><br>Now you are become a registerd member of Onlines2s.com. <br><br>Your User Id and Password will be sent to you shortly in your email address.</b></font><br><br>";
}
mysql_close($con);
?>
Pl let me know where the problem lies and its solution. Treat this as most urgent
thanks & regards
Subho