Simple Insert Statement, well...

donald3

Hello!

I'm making up a survey, but unfortunately I cannot get this statement to work...

$sql="INSERT INTO survey VALUES('$age','$region','$internet','$music','$download','$songs','$cd','$opinion','$students','')";

mysql_query($sql, $connection) or die ("<p>Error occurred while submitting survey.</p>");

When I run it, I get the Error message. I echoed out the variables, and they are being passed, but the data is not making it to the database. I have the following survey table

(age, region, internet, music, donwload, songs, cd, opinion, students, id)

Anybody have any good ideas? This is as simple as it gets, but I'm struggling 😕

Thanks!
Donald

sarahk

echo out the sql and copy into MySql/phpMyAdmin etc and see what error message you get there.

Have you addslashes() to your data? Is there a chance there is an extra ' in there somewhere?

donald3

Its just a form (survey) with radio buttons and drop-down menus, so there isn't any extra ' in there. I'll try putting the query statement into phpmyadmin. I'll let you know what happens...

-Donald

donald3

Okay, I made the query, AND THERE IS NO ERROR!!! 😕 So, I'm not sure what I am to do? Does this mean the error is in my form? I guess I don't know what could be wrong with the form... any suggestions?

-Donald

tomhath

See what mysql thinks is wrong:

mysql_query($sql, $connection) or die ("<p>Error occurred while submitting survey " . mysql_error() . "</p>" );

Also, is the id column an autoincrement? If so you should be passing NULL, not an empty string.

donald3

Okay, but that is only a syntax issue, plus it does work. But, that doesn't solve my problem, it just doesn't make any sense! MySQL will take the query (the insert statement above) but through PHP it does not.

-Donald

kevinsequeira

what is your survey table structure ?

reg
kevin

superwormy

USE mysql_error() TO FIND WHERE YOUR ERROR IS!

mysql_query ($sql, $conn) or die (mysql_error());