Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

SQL Query getting form ID, but not submitted data
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: SQL Query getting form ID, but not submitted data
#28746
SQL Query getting form ID, but not submitted data 12 Years, 6 Months ago Karma: 0
Hello,

I am pulling data out of SQL by using: "SELECT * FROM j17_rsform_submissions WHERE `FormId`='3'" But I am not getting the submitted data to come up. I am getting this data from RSForm Pro Tables just in case you have dealt with them.

The only fields that come up are:
SubmissionId
FormId
DateSubmitted
UserIp
Username
UserId
Lang
confirmed

I want to generate the submitted data, not the form structure.

Any help would be greatly appreciated as I am under a deadline.

Thanks!
The administrator has disabled public write access.
 
#28747
Re:SQL Query getting form ID, but not submitted data 12 Years, 6 Months ago Karma: 760
Hello,

Sorry, but we don't know structure of your tables. Could you send SQL dump of table(s) by email and specify what results do you expect?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#28748
Re:SQL Query getting form ID, but not submitted data 12 Years, 6 Months ago Karma: 0
I'm looking for the correct SQL dump expression as I am being warned about doing so from MyPHPAdmin.
The administrator has disabled public write access.
 
#28750
Re:SQL Query getting form ID, but not submitted data 12 Years, 6 Months ago Karma: 760
Yes, PHPMyAdmin supports this feature.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#28751
Re:SQL Query getting form ID, but not submitted data 12 Years, 6 Months ago Karma: 0
Is it the same as "Export"? If so, what format do you want it in? If not I don't know the Dump command to use. I'm fairly new to MySQL.

Thank you for your quick response already!
Last Edit: 2012/05/30 19:43 By pfinkie.
The administrator has disabled public write access.
 
#28753
Re:SQL Query getting form ID, but not submitted data 12 Years, 6 Months ago Karma: 0
I really want to get this to you, I just don't know how or in what format. I think I can also limit the Database to just tables related to rsForm as well.

Are you there???
Last Edit: 2012/05/30 21:55 By pfinkie.Reason: No response.
The administrator has disabled public write access.
 
Go to topPage: 123