Problems with data alignment in XSLT with nested tables

Question

I'm generating a Word document via FoundationPHP using XSLT and nested tables.

My desired results would be:

Table 1        Table 2
Image 1        Image 2
Label 1        Label 2
Data 1         Data 2

Table 3        Table 4
Image 3        Image 4
Label 3        Label 4
Data 3         Data 4

Table 5
Image 5
Label 5
Data 5

However, what I am getting is:

Table 1        Table 2
Image 1        Image 2
Label 1        Label 2
Label 1        Label 4

Table 3        Table 4
Image 3        Image 4
Label 3        Label 4
Data 2        Label 5

Table 5
Image 5
Label 5
Data 3

My XSLT code (simplified for posting purposes)

As you can see, the image and the label are correct, however the data is coming in vertically. I've been staring at this code to the point where my double vision is making me second guess everything.

EDIT: This is the XML output from my script. (I only included 3 rows)



    
        10755
        10755/11786.jpg
         8220 Southwest Warm Springs Street
    
    
        10493
        10493/11786.jpg
         21101-21149 SW 115th Avenue
    
    
        11008
        11008/11786.jpg
         7144 NW Progress Court

To make the question more complete, here is the code to get the data:

if ( isset( $_GET[ 'id' ] ) ) {
    $sql = "SELECT ID, data, image FROM property WHERE ID in (" . $_GET['id'] .") ORDER BY field(ID," . $_GET['id'] .")";
    $result = $db->query($sql);
    if ($db->error) {
        $error = $db->error;
    }
}
}

function getRow($result) {
    return $result->fetch_assoc();
}

MAM · Accepted Answer

In your first call to data, change to

Then, on your second call, use

This should line up the data the way you want.

Problems with data alignment in XSLT with nested tables

Answers (2)

Related Questions