I need to sortering my DB (staff company with surname, forename, phone, etc.) in a catalogue view in 2 columns; the first column may be filled with the staff people sorted by forename, from A to K, and the second column wiht his forename from L to Z.
Please, any idea?
Now, this is my best way but is sorted in rows, not in columns and I don´t know how can I fill from A-Z:
<!-- LOOP Start -->
<div class="joocte_container">
{joodb loop}
<div class="joocte_element">
{joodb ifis|NOMBRE|KATHLEEN|le}
<table class="table-hover" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="width: 95px; nowrap;">
<font size="2">{joodb NOMBRE}</font></td>
<td style="width: 150px; nowrap;">
<font size="1">{joodb APELLIDO}</font></td>
<td style="width: 30px; nowrap;">
<font size="1">({joodb INICIALES})</font></td>
<td style="width: 30px; nowrap;">
<a class="cte-link" href="callto:{joodb EXTENSION}">{joodb EXTENSION}</a></td>
<td style="width: 20px; nowrap">
</td>
</tr>
</tbody>
</table>
{joodb endif}
{joodb ifis|NOMBRE|KATHLEEN|ge}
<table class="table-hover" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="width: 95px; nowrap;">
<font size="2">{joodb NOMBRE}</font></td>
<td style="width: 150px; nowrap;">
<font size="1">{joodb APELLIDO}</font></td>
<td style="width: 30px; nowrap;">
<font size="1">({joodb INICIALES})</font></td>
<td style="width: 30px; nowrap;">
<a class="cte-link" href="callto:{joodb EXTENSION}">{joodb EXTENSION}</a></td>
<td style="width: 20px; nowrap">
</td>
</tr>
</tbody>
</table>
{joodb endif}
</div>
{joodb loop}<!-- LOOP End -->
<h3>
{joodb nodata}</h3>
<!-- LOOP Pagination -->
<p>
{joodb pagecount}</p>
<div class="pagination">
{joodb pagenav}</div>
</div>
Thx in advance