[RESOLVED] No Errors, but no posting to DB

suthen_cowgirl

I'm stumped...maybe its because its late, I don't know.

I renamed a couple files, modified some old code that still works on the original pages, checked the database connection - yep it connected, checked all the names to make sure I didn't mis-spell something - couldn't find anything, been looking at it for hours now before I decided to ask.

Is there any common things I should look for other than what I said I've already looked for?

Both pages (the first is a form with a submit button, goes to the second that says thanks) work just fine - I don't get any errors, but when I go into phpMyAdmin to look at my table there are no results so its not posting any of the variables!?

I'll post code if I need to, but I thought there might be some common things to look for first, probably just one of those not thinking of it things.

Thanks in advance!

Piranha

Try to start the files with this row:Is display_errors set to On? Is error_reporting set to E_ALL? Do you get any kinds of messages from PHP at all?

When you do the query, do you output any error message from MySQL?

leatherback

=> Echo the query you send to the database before sending it, and spit out the mysql error:

$query = "insert ... into ... ";
echo $query;

$result = mysql_query($query) or die($mysql_error());

That should help you solve it.

If it doesn't: Please post the code you use to:
=> Retrieve the posted data
=> Insert the data

and post the messages that the code above creates.

suthen_cowgirl

Ok, the echo of the query:

INSERT INTO sn_rules (Prop1-A1, Prop1-C, Prop1-D4, Prop1-G, Prop1-H, Prop2, Prop3, Prop4, Prop5, Prop6) VALUES ('Keep', 'Keep', 'Keep', 'Keep', 'Keep', 'Option2', 'Keep', 'Keep', 'Keep', 'Keep')

And yes, those are all suppose to be the same answer - 'keep'. 🙂

The code:

//Save the form values to local varables
$strProp1A1 = $POST['Prop1-A1'];
$strProp1C = $POST['Prop1-C'];
$strProp1D4 = $POST['Prop1-D4'];
$strProp1G = $POST['Prop1-G'];
$strProp1H = $POST['Prop1-H'];
$strProp2 = $POST['Prop2'];
$strProp3 = $POST['Prop3'];
$strProp4 = $POST['Prop4'];
$strProp5 = $POST['Prop5'];
$strProp6 = $POST['Prop6'];
//Create an insert query string with the new response data
$strInsertQuery = "INSERT INTO sn_rules (Prop1-A1, Prop1-C, Prop1-D4, Prop1-G, Prop1-H, Prop2, Prop3, Prop4, Prop5, Prop6) ".
"  VALUES ('$strProp1A1', '$strProp1C', '$strProp1D4', '$strProp1G', '$strProp1H', '$strProp2', '$strProp3', '$strProp4', '$strProp5', '$strProp6')";[/QUOTE]
And the "fields" in phpMyAdmin db table are the ones without the hyphens.

The only thing I can think of is I mis-did a ' or " on the first page but I swear I looked and looked and can't find anything, plus the page displays just fine and thats basically all it is, is creating the form on the first page.

leatherback

And what did this give you:
$result = mysql_query($query) or die($mysql_error());

(If it didn't give you anything, I am pretty sure it never arrives there.

Check that with echo comments before and after:

echo "Yes Before";
$result = mysql_query($query) or die($mysql_error());
echo "Yes After";

in which cas eyou need to check the logic of your script

suthen_cowgirl

I got the "Yes Before"

Then it said "fatal error: call to undefined function" on the result line that I added the "die" thing...so I would assume that has to do with the die thing not being defined somewhere else..(its been so long since i used these files but..) the only place i see right off where error stuff is listed is on my connect page where it says:

//Check if connection worked.
if (!$conMySql)
{
echo "Error: Could not connect to the database. \n";
echo "mysql_errno() = ".mysql_errno($conMySql)." \n";
echo "mysql_error() = ".mysql_error($conMySql)." \n";
exit;
}
else
{
echo "";
echo "Succeeded in connecting to the database. <br><br>";
}

And it did...because I removed the "die" part and I got the "Yes After" then. 🙁 sigh Guess I'll just have to erase everything and start over. Cause technically this 2nd page is working - no errors etc.

Think I tried to add too much HTML into the first page, that I never had the other times I've used this exact same code, then I went back and added the PHP tags, mustve screwed up something on that page.

leatherback

If you use this construct:

$result = mysql_query($query) or die(mysql_error());

it will tell you what went wrong in the query.

If it did not insert it, this WILL return a reason why not.

Alternatively, you could copy the echoed query and post that directly to the database (e.g., through phpadmin) to get the error from the database.

bradgrafelman

If you'll notice, leatherback has corrected his original error - in his code above, he suggested this:

$result = mysql_query($query) or die($mysql_error());

Note that there was an extra $ before the [man]mysql_error/man function.

EDIT: On a hunch, I went and fiddled around on my test SQL server and found the issue. Your column names have hypens in them, which also mean subtraction when not inside a string. As such, MySQL probably thinks you're throwing a subtraction operator while defining column names, and is getting rather confused.

The solution is to surround your column names with backticks ( ` ). In fact, when writing queries, I almost always surround all table, database, and column names with backticks - that way I will avoid problems such as this one. Here's an example of what I mean:

INSERT INTO `myTable` (`column1`, `column-2-b`) VALUES ('this query', 'will work');

suthen_cowgirl

Thanks bradgrafelman, I kept fiddling with it and ended up changing the names to not hyphens - just trying anything (which I thought I had tried before, guess not) - and it started working, but now after reading your response I understand better why it didn't work, so thank you.