• 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: Exporting conditional data / SQL Export

Exporting conditional data / SQL Export 9 years 7 months ago #32535

  • robert.wooler
  • robert.wooler's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 14
  • Thank you received: 1
I have a form that collect data and all is working fine

What i want to be able to do now, is export data but data that matches a particular rule

Basically i want to export all the email address from my submissions, but only the email that the user has ticked a box for us to use that email address

i have a field 'email' and another 'noinfoplease' the noinfoplease is a dropdown, with the values Do not use and Okay to use

Any ideas how to go about it?

i have tried with server backend / phpMyAdmin

but the sql language is a little different, i keep getting errors, is seems to what a differnt type of quotes around the fields than normal sql commeands, if i use their editor it adds `` this type and not '' but this confuses me when i want to create the query and the value


Any help appreciated

Rob
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!