Undefined variable error

Hi again,

Now that our officer election is over, I'm updating our election pages using your MySQLi extension. See the attached file - when I make election choices and then hit Submit, I'm getting the following error messages:

Notice: Undefined variable: voterRecordset_i in /home/gcssepm/www/2014election_3.php on line 25

Fatal error: Call to a member function getColumnVal() on a non-object in /home/gcssepm/www/2014election_3.php on line 25

I've attached the file. Can you spot where I've gone wrong?

Gail

In the update behavior, you are using the recordset bindings, you should be using the form bindings instead.

Hmmm. I made that change, and it got rid of the error messages, but the form is still not posting back to the database. File attached.

Try using any form post as the update trigger.

Nope. It didn't make a difference. Any other ideas?

I'll need to troubleshoot directly, see the private message section.

see below

looking at the source code for the page shows an error on the user id form element:

<input type="hidden" name="user_id" value="<br />
<b>Notice</b>: Undefined variable: row_voterRecordset in <b>/home/gcssepm/www/2014election_3.php</b> on line <b>540</b><br />
" />


the user id form element is using the old mySQL binding for the value:
<input type="hidden" name="user_id" value="<?php echo $row_voterRecordset['user_id']; ?>" />

it needs to be updated to use the MySQLi binding instead

Thank you Jason, that did the trick. The form is now posting properly.

Gail

you're welcome.