Hi there (newbie here) - I have the following snippet of code......
$sexId = $_POST['sex']; $fName = $_POST['fName']; $lName = $_POST['lName'];
if ($status = $db->query("INSERT INTO names (nameId, sexId, fName, lName) VALUES ('', $sexId, '$fName', '$lName')")) {
print "Your data was added to the database successfully!";
} else {
print "Your data could not be added to the database!";
}
Assuming my query was successful, should it not return true and print the success message?
For some reason it is doing just the opposite. The data is added, but it displays the error instead.
Am I misunderstanding something?
Hmmm... couple of things:
Your if statement isn't checking the value of '$status'. It's checking if the assignment *to* $status is true or false. At least I think so.
So, I think at a minimum you want:
if ( $db->query.....
Also, what is $db->query supposed to return upon success? In the unix world, programs typically return zero to indicate success and use other values to differentiate b/n all the possible errors. if $db->query is doing that, then that's the problem.
good luck.
-philip
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
