• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Checking to see if a date in a database has alread

Checking to see if a date in a database has alread 10 years 7 months ago #28948

  • john0784
  • john0784's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
Hello Everyone,

I need to make sure that no one can select a date if it has already been chosen. Is there a good way to do this?

Thanks, John
The administrator has disabled public write access.

Checking to see if a date in a database has alread 10 years 7 months ago #28954

  • cosmin.cristea
  • cosmin.cristea's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 756
  • Thank you received: 144
In order to achieve this you will need to create a PHP Script Called on Form Process to query the database like :
"SELECT COUNT(`FieldValue`) FROM #__rsform_submission_values WHERE `FieldName`='your_date_field' AND `FieldValue` = '".$_POST['form']['field_name']."' AND `FormId`='".(int) $formId."' "

Depending on the result, you should invalidate the form-field. Good luck!
My help is not official customer support. To receive your support, submit a ticket by clicking here
The administrator has disabled public write access.
The following user(s) said Thank You: john0784
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!