|
|
Posted by Philip Hallstrom on 05/21/05 01:09
> 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
Navigation:
[Reply to this message]
|