Basic Form?

hsANDn 19 Mar, 2012
Greetings,

First of all, thank you developers for this wonderful extension! I'm still experimenting with it because i'm not familiar with php and mysql coding. (so please bear with me for my ignorance 😶 ) On to my question.

There are just 3 elements in my form, a text area with field name 'input_nick', select box with field name 'input_goals' (this one is basically made up of numbers) and the submit button. So i followed the tutorials on this site and managed to display the name as well as the number of goals scored per name using another form called 'list_form'.

However, the problem is that, I am able to submit the same name repeatedly and the 'list_form' still display it. My question is, is there a way to check for the same name and if there is, the number of goals scored will be automatically updated.

Eg.
Name A - 3 goals
Name B - 1 goal
Name A - 2 goals

So this way, with the check, the table being displayed will now be:

Name A - 5 goals
Name B - 1 goal


Thank you in advanced for any help rendered!

Regards,
hsANDn
GreyHead 24 Mar, 2012
Hi hsANDn,

Yes you can but you may need some more experienced help in getting this to work. You need to identify the users and add code to update their record rather than adding a new record to the table. This isn't terribly difficult but it does depend on how you have your tables and form set up and is more than I can describe in a five minute post here.

Bob
This topic is locked and no more replies can be posted.