• 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: Check for 1st subscription for a particular day

Check for 1st subscription for a particular day 9 years 4 months ago #33314

Folks,
I just cant work this code out.... can anyone help me with it?
I want to test if there are no other entries for the particular date entered....

I have a form with a date input field (a date popup calendar field).

I am looking on the table: "_rsform_submission_values", and in the fields, FormId FieldName & FieldValue where Filedname=Date (the name of my date input field).

in the "Script called after form has been processed" area, If I can count if there is only ONE submission with this date (for this formid), then I can construct a message to indicate this.
Unfortunately I'm not too SQL savvy, so am having problems getting this done.

appreciate any help!

Mike
The administrator has disabled public write access.
  • 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!