Query Failed

[alvinchua]

Hello, I have a problem where my script always giving me the error 'Query Failed'. Can anyone help me to figure out what is the problem with my code ? Thanks in advanced

 

 

<?php 
if(!require('connection.php')){

echo "Error in page process!";
}
$name=$_POST['name'];
$country=$_POST['country'];
$address=$_POST['address'];
$email=$_POST['email'];
$inquiry_type=$_POST['inquiry_type'];
$message=$_POST['message'];
$date=$_POST['date'];
$sql = "INSERT INTO inquiry VALUES(NULL,'".$name."','".$country."','".$email."','".$address."','".$inquiry_type."','".$message."','".$date."');";
$result = mysql_query($sql) or die ("Query failed!");
$to = "[email protected]";
$headers = "From:$email";
$sent = mail($to, "New inquiry", "Inquiry type:$inquiry_type\nPlease go to admin page to check the new inquiry.\n http://www.2ndhome-intl.com/admin/", $headers) ;
if(!$sent)
{print "We encountered an error sending your inquiry, please try again!"; }
else
{?>
<script language="javascript" type="text/javascript">
alert("Your inquiry has been submitted, Thank you");
window.location = "index.php";
</script>
<?php 
}?>

[PFMaBiSmAd]

Why not get php/mysql to tell you why it failed. Add a mysql_error() statement to your die() statement -

 

$result = mysql_query($sql) or die ("Query failed! " . mysql_error());

 

P.S. A require() statement that fails is a fatal runtime error. Code execution stops at the require() statement and your echo "Error in page process!"; will never be executed if the require() fails.

[Ken2k7]

Possible case:

 

<?php 
if(!require('connection.php')){

echo "Error in page process!";
}
$name=mysql_real_escape_string($_POST['name']);
$country=mysql_real_escape_string($_POST['country']);
$address=mysql_real_escape_string($_POST['address']);
$email=mysql_real_escape_string($_POST['email']);
$inquiry_type=mysql_real_escape_string($_POST['inquiry_type']);
$message=mysql_real_escape_string($_POST['message']);
$date=mysql_real_escape_string($_POST['date']);
$sql = "INSERT INTO inquiry VALUES(NULL,'".$name."','".$country."','".$email."','".$address."','".$inquiry_type."','".$message."','".$date."');";
$result = mysql_query($sql) or die ("Query failed!");
$to = "[email protected]";
$headers = "From:$email";
$sent = mail($to, "New inquiry", "Inquiry type:$inquiry_type\nPlease go to admin page to check the new inquiry.\n http://www.2ndhome-intl.com/admin/", $headers) ;
if(!$sent)
{print "We encountered an error sending your inquiry, please try again!"; }
else
{?>
<script language="javascript" type="text/javascript">
alert("Your inquiry has been submitted, Thank you");
window.location = "index.php";
</script>
<?php 
}?>

[PFMaBiSmAd]

Posting "fixed" code without any explanation of what it corrects or does differently, teaches nothing.

 

It's also possible that while the external data does need to be escaped, that the actual cause of the failed query is due to something else.

[radomTraveler]

Are you cenrtain that the table exists?  And that all fields exist, and that there are no typos?

[alvinchua]

hmm i tried the code posted here but it give me the same error. i have include this line into my code

$result = mysql_query($sql) or die ("Query failed! " . mysql_error());

 

and it give me the error as below

 

Query failed! Duplicate entry '127' for key 1

 

anyone ?

[PFMaBiSmAd]

Your table definition has a TINYINT for one of the indexes and you have used all the available values. You should use at least a normal INT for an index. Alter your table and change the column that is a TINYINT into an INT data type.