Posted by Sammi
2013-11-12


Thanks Tom,

So regarding this... I have tried to remove the fields from the form, and took out those )(g_reg_page1)(g_reg_page2)(g_reg_save).. yues, it's not showing on enquiry page of coz, but when it goes to the search.details, these fields can show, but after i clicked save, the field data is all GONE, (overwritten by empty space). How can I do this?


One more question,
In the form, I have a EMAIL field, which is unique (no duplicated email should be allowed)
I wanna put a SQL for checking repeated email, which file and how should I do this?
If i change the data type to email (unique), there's sometimes email is not mandatory and all blank .. so this doesn't work either.

Any suggestion?
Thanks!
Posted by Tom
2013-11-13

>but after i clicked save, the field data is all GONE,

(g_XXXXX) won't affect operations in the admin panel. You must've removed something else from XA_LIST. Maybe, it's time to check the original again?

>I wanna put a SQL for checking repeated email,

You can check the source code of web/staff/app/cls_ps_staff.inc.php. It has the code that prevents users from entering the same username. You may be able to copy and modify it for checking the email duplication. Another approach is, if you are into ajax, that you can detect the form submission using javascript/jQuery and send the email address to a script that checkes the email duplication.