nested dependent vb:each - building headers for sorting

[wpeloquin]

Hello,

I have tried numerous ways, but am beginning to think this not possible (or i'm just stuck looking at it from a single angle), so figured i'd try to get some outside opinions/help.

In my php file, i create an array that looks like the following:

    while ($wp_alist = $vbulletin->db->fetch_array($wp_fulllist))
    {
        $wp_list[$count] = array(
            'id' => htmlspecialchars($wp_alist['id']),
            'name' => htmlspecialchars($wp_alist['name']),
            'locid' => htmlspecialchars($wp_alist['locid']),
            'location' => htmlspecialchars($wp_alist['location']),
            'url' => htmlspecialchars($wp_alist['url'])
        );
        $count++;
    }

    $templater->register('wp_list', $wp_list);

In my template, i can successfully display the entire list using

<vb:each from="wp_list" value="list">
<tr>
	<td>{vb:raw list.location}</td>
	<td><a href="{vb:raw list.url}">{vb:raw list.name}</a></td>
</tr>
</vb:each>

However, what i would like to do is separate the items based on the location, something similar to the image that i attached. A rough code might be something like this, but i know that vb:raw cannot be used in a conditional, and i cannot figure out how to work around this.

<vb:each from="wp_list" value="location">
<h1>{vb:raw location.location}</h1>
	<vb:each from="wp_list" value="list">
	<vb:if condition="{vb:raw loc.location} = {vb:raw scroll.location}">
	<tr>
		<td>{vb:raw list.location}</td>
		<td><a href="{vb:raw list.url}">{vb:raw list.name}</a></td>
	</tr>
	</vb:if>
	</vb:each>
</vb:each>

[kh99]

I think that appraoch will work but you might need to create your own array of locaitons and register it too. Maybe try something like this:

    while ($wp_alist = $vbulletin->db->fetch_array($wp_fulllist))
    {
        $locations[] = htmlspecialchars($wp_alist['location']);
        $wp_list[] = array(
            'id' => htmlspecialchars($wp_alist['id']),
            'name' => htmlspecialchars($wp_alist['name']),
            'locid' => htmlspecialchars($wp_alist['locid']),
            'location' => htmlspecialchars($wp_alist['location']),
            'url' => htmlspecialchars($wp_alist['url'])
        );
    }
    $locations = array_unique($locations);
    $templater->register('wp_list', $wp_list);    
    $templater->register('wp_locations', $locations);

and then in your template:

<vb:each from="wp_locations" value="location">
<h1>{vb:raw location}</h1>
	<vb:each from="wp_list" value="list">
	<vb:if condition="$list['location'] == $location">
	<tr>
		<td>{vb:raw list.location}</td>
		<td><a href="{vb:raw list.url}">{vb:raw list.name}</a></td>
	</tr>
	</vb:if>
	</vb:each>
</vb:each>

I'm not sure of there's any way to use the value from the outer vb:each to specify the inner vb:each array. That would make things a little more efficient.

[wpeloquin]

That didn't work (for me, anyways). I think it still sees the objects in the IF statement as <vb:raw> statements...

[kh99]

I did have one error in the code above, which I just fixed. It said location.location when it should just be location. Also I left out the htmlspecialchars when setting the locations array. But I did test it and it basically seemed to work. What happens when you try?

[wpeloquin]

I had to play with the <table> tag and it is working now (see below). Much thanks kh99! I was on the right track it seems, just off on the syntax. You saved me many hours of tedious hair pulling

<vb:each from="wp_locations" value="location">
<h1>{vb:raw location}</h1>
<table>
	<vb:each from="wp_list" value="list">
	<vb:if condition="$list['location'] == $location">
	<tr>
		<td>{vb:raw list.location}</td>
		<td><a href="{vb:raw list.url}">{vb:raw list.name}</a></td>
	</tr>
	</vb:if>
	</vb:each>
</table>
</vb:each>