Updating fields using Admin Update page

Hi there,

Me again! I've almost completed my project and am having one final problem.

I have created some extra fields in my users database and managed to create some dynamic pages which pull this information into my Clients Login pages - everything is working great.

I have also managed to copy and rename the Admin "usersUpdate.php" page and modify it to show these new fields when I am administrating any new registrations and backend Admin etc. The problem comes when I try to update the data for these new fields using the newly copied page - the updates don't seem to be being applied to my database - the previous default fields like Name and Email etc all update fine - it just seems to be the new ones I've created which don't. Obviously there is something which I've omitted and that is the reason why it's not working but I've looked over the new .php page and I just can't see what I've missed.

Any help would be appreciated to finish my project.

Thanks guys.

One good way to see how a site is put together is to look to see how other variables are used. Pick one that works and try this:

185/

Thanks. I've had a look at the link you have provided.

Seems I've got a problem with updating fields using the users_Update.php file in my Admin Back End section.

I thought it was just my new .php update page, which I had created, that wasn't working but it would seem that the default page isn't working as well. Have tried deleting the users_Update.php file and replacing it with a brand new unedited version from the original downloaded software but it still isn't working.

Front End field updating works great via users_Profile.php and updates the database just fine but when I login to the admin area I can see the details and fields, via users_Update.php, but there is no change to the database once I have pressed the "Update" button.

Anyone have any ideas?

you will need to edit the Update Record Server behavior on the update page and bind the new form elements with the corresponding database columns.

You will need to have DataAssist installed for this.

In the Server Behaviors list, double click the update record server behavior. On the second page, select one of the new database columns, click the lightning bolt next to value and select the Corresponding form element.

I think the problem is that the form is showing a "Please enter a phone number." error message and that's the reason the form is not updating. I am using British phone numbers and maybe the software is set to american style.

Does anyone know which files I need to alter and what code I need to use? I'm pretty sure if I don't get the "phone number" error then the page should update - problem solved hopefully..

Thanks for any assistance.

**Update**

I've found the problem and it's what I thought it was - an error reading the British style phone number whilst updating the records. If anyone has the same problem I went to the Admin folder opened the users_Update.php page and changed the following line to enable to page to recognise the British style phone number. The line originally read:

$WAFV_Errors .= WAValidatePN(((isset($_POST["UserPhone"]))?$_POST["UserPhone"]:"") . "",true,false,true,8);

and once I changed it to:

$WAFV_Errors .= WAValidatePN(((isset($_POST["UserPhone"]))?$_POST["UserPhone"]:"") . "",false,true,true,8);

everything worked fine and the page now updates the database.

Having a problem with a field when I go to update it.

I input details into the field and press the update button but the field updates with a "0" and not the data I have typed - it also updates the database with this zero so at least that is something.

I've checked the code a million times but again can't see what's causing it - anyone have any ideas why the field won't update with the keyed information and replaces it with a zero?

Thanks again for all your help.

Hard to say without seeing the code.

Please send a copy of your page.

Thanks

Here's the page that's causing me the probs. All fields are updating fine except for the "Support Team Messages" field - this is the one that changes the input text to a zero and updates my database with a zero.

which field is updating with the zero?

Hi there,

It was the Support Team Messages field that's not functioning - all other fields are working properly.

Many Thanks