Hi all:
I have a table, members, it has few fields, id, fname, lname, adres, .... , membership
What I want to do is query the table in way that the result would be ordered by memberships, but within each membership ordered by name.
Sorry if it sounds vague. The sample result I'm looking for is:
<table width="90%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td>Membership </td>
<td>Lastname</td>
<td>First Name </td>
</tr>
<tr>
<td>1</td>
<td>Ardiles</td>
<td>Monica</td>
</tr>
<tr>
<td>1</td>
<td>Basquez</td>
<td>Jason</td>
</tr>
<tr>
<td>1</td>
<td>Smith</td>
<td>Alex</td>
</tr>
<tr>
<td>1</td>
<td>Williamson</td>
<td>Adam</td>
</tr>
<tr>
<td>2</td>
<td>Schmidt</td>
<td>Peter</td>
</tr>
<tr>
<td>2</td>
<td>Tevez</td>
<td>Jennifer</td>
</tr>
<tr>
<td>2</td>
<td>Valdez</td>
<td>Michelle</td>
</tr>
<tr>
<td>3</td>
<td>Smith</td>
<td>Will</td>
</tr>
<tr>
<td>3</td>
<td>Willis</td>
<td>Bruce</td>
</tr>
</table>
DAMN! I can't even get the table to show!
I can pdf it if needed!
HEEEEEEEEEEEEELP!
