Je cherche à afficher et à organiser les entrées de mes différents formulaires (extension GravityForms)
Voila ma requête
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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 : Sélectionner tout - Visualiser dans une fenêtre à part
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