Why won't mysql query with my php script?

Question

I'm trying to make this information insert into my table in mysql database with this script I wrote.

<?php
require("../includes/db.php");
$nme = $_POST["nme"];
$email = $_POST["email"];
$address = $_POST["address"];
$city = $_POST["city"];
$state = $_POST["state"];
$zip = $_POST["zip"];
$phone = $_POST["phone"];
$options = implode($_POST["options"],", ");
$query = mysql_query("insert into peeps (name, email, address, city, zip, phone, type) values ('$nme','$email','$address','$city','$state','$zip','$phone','$options')");
if($query)
    print "yes";
else
    print "no";

?>

The output of this code is no.

@zachdyer You should not use the mysql_ functions any more (read more). Use the mysqli (notice the i) class instead. Also, you are open to SQL injection attacks. — Levi Morrison
– Levi Morrison, Commented Feb 8, 2012 at 5:37

Gabriel Bauman · Accepted Answer · 2012-02-08 05:27:30Z

1

If mysql_query() returns false, it means the query failed.

Try this:

if (false === $query)  // make sure it's actually boolean false
  print mysql_error(); // print a nice plain-english description of the problem.
else
  print "Yes";

This should give you a good idea of where the problem is.

answered Feb 8, 2012 at 5:27

Gabriel Bauman

2,4161 gold badge26 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

zachdyer Over a year ago

Thank you. 'state' did not exist in my table so I added it. Now it works great.

Prasad Rajapaksha · Accepted Answer · 2012-02-08 05:38:26Z

1

If you modify this part of your code you can see the exact error you get.

if($query)
{
    print "yes";
}
else
{
    print mysql_error(); ;
}

However the way you have written may generate errors if you do not have enabled Magic Quotes. If you have that kind of error you better use mysql_escape_string

answered Feb 8, 2012 at 5:38

Prasad Rajapaksha

6,18810 gold badges40 silver badges53 bronze badges

Collectives™ on Stack Overflow

Why won't mysql query with my php script?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related