Afficher entrées GravityForms
Je cherche à afficher et à organiser les entrées de mes différents formulaires (extension GravityForms)
Voila ma requête
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
$query2 = "
SELECT wp_rg_lead.date_created,
wp_rg_lead_detail.lead_id,
wp_rg_lead_detail.form_id,
wp_rg_lead_detail.field_number,
wp_rg_lead_detail.value,
wp_rg_lead.source_url,
wp_rg_lead.user_agent
FROM wp_rg_lead_detail INNER JOIN wp_rg_lead ON wp_rg_lead_detail.lead_id = wp_rg_lead.id
WHERE wp_rg_lead_detail.form_id = '2'
ORDER BY wp_rg_lead_detail.lead_id, wp_rg_lead_detail.field_number ASC
";
$myResultRows2 = $wpdb->get_results($query2, OBJECT); |
Quand je fais un print_r, j'obtiens:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
|
Array
(
[0] => stdClass Object
(
[date_created] => 2013-07-08 13:34:18
[lead_id] => 2
[form_id] => 2
[field_number] => 1
[value] => M.
[source_url] => localhost/dev/inscription-newsletter
[user_agent] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36
)
[1] => stdClass Object
(
[date_created] => 2013-07-08 13:34:18
[lead_id] => 2
[form_id] => 2
[field_number] => 2
[value] => testnom
[source_url] => localhost/dev/inscription-newsletter
[user_agent] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36
)
[2] => stdClass Object
(
[date_created] => 2013-07-08 13:34:18
[lead_id] => 2
[form_id] => 2
[field_number] => 3
[value] => testprenom
[source_url] => localhost/dev/inscription-newsletter
[user_agent] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36
)
[3] => stdClass Object
(
[date_created] => 2013-07-08 13:34:18
[lead_id] => 2
[form_id] => 2
[field_number] => 4
[value] => testcodepostal
[source_url] => localhost/dev/inscription-newsletter
[user_agent] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36
)
[4] => stdClass Object
(
[date_created] => 2013-07-08 13:34:18
[lead_id] => 2
[form_id] => 2
[field_number] => 5
[value] => 06.13.24.56.78
[source_url] => localhost/dev/inscription-newsletter
[user_agent] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36
)
) |
Quelqu'un peut, il m'aider à organiser cela?
Je souhaite afficher sur une ligne les différent élément d'un entrée
Merci