Please replace the ??? with your data!

• Your URL: http://www.micromann.com
• The browser used: firefox
• cforms version: latest
• Your Wordpress version: latest

[desc]:
_Hi friends,

The data stored in cforms created tables is in vertical format rather than horizontal and I find it difficult to fetch for a display on a different page..

Kindly guide..

thanks in advance

bhavesh ruparelia

hi oliver,

I have uploaded a mysql database of a cforms form at..

http://www.micromann.com/images/form20.txt

it needs to be imported to your mysql database..

and it is to be displayed as per the image at

http://www.micromann.com/images/form20.JPG

- What I specifically mean is that the data is stored in the database in the vertical column format, while I need to diplay in the page in the horizontal row format..

Kindly guide..

- Also which databse storage format is better in performance- vertical column storage or horizantal row style ?

thanks in advance

bhavesh r

thanks oliver..

When do you expect to launch the version 9 with the semi api solution ?

thanks & goodluck

bhavesh r

oliver,

If there is a solution to fetch-display the data in the beta as mentioned in your reply…kindly send the beta to my email admin@micromann.com

thanks & goodluck

bhavesh r

thanks a lot oliver..

I'll try v 9.0 beta now..

thanks again

bhavesh r

It returns:

SELECT * FROM wp_circus_cformssubmissions WHERE form_id IN ('2') ORDER BY id LIMIT 0,<br>SELECT * FROM wp_circus_cformsdata WHERE sub_id IN ()<br>

as if it has been echo'd, and any variable I set to get_cforms_entries()
is empty

Sorry, don't understand at all – the help file says:

get_cforms_entries('','','','','') will "return a set of stored form submissions in a multi-dimensional array."

using code in a wordpress template file eg:

 $Names =get_cforms_entries( 'Social media surgery signup', '', '', '', '' );
print_r ($Names);

should in theory print to the browser the array – so i can investigate the structure and then write the php to output what I want. It doesn't. (btw the code is outside the WP 'loop', but that shouldn't me an issue?).

The function prints what looks like an MYSQL query to the  html page, and the array prints as empty:

SELECT * FROM wp_circus_cformssubmissions WHERE form_id IN ('2') ORDER BY id LIMIT 0,
SELECT * FROM wp_circus_cformsdata WHERE sub_id IN ()
Array ( )

Looking at the HTML code the "query" has <br/>s in it. Trying to build an MYSQL query and use statement only bring up an error that the query  doesn't work.

So either the help file could do with a little extra into, or there's a bug/issue with my set-up.