Displaying Results

[Rhyan]

Using PHP/MYSQL, I am trying to display a table with 2 columns.

Names that begin with aaa_ and that begin with bbb_, which are all together in a table field named Names so it'd look like this:

__________________________
aaa_kdjkjf | bbb_ijkjeje |
aaa_terem | bbb_imeeee |
aaa_chack | bbb_bamju |
---------------------------

Anyone have a clue, I figured you had to do a sort, but wasnt sure how to do multiple sorting and displaying.

Thanks

 

[devnull22]

Hi Rhyan,
You could use two queries, 1 with aa's and the other
with bb's.

Then use two HTML tables within one HTML table
ie.

<table border=0>
<tr>
<td><!-- col 1-->
<table ... print results ..

</td>
<td><!-- col 2-->
<table ... print results ...
</td>
</tr>
</table>

that should give you two columns , one with a's the
other with b's.

Cheers

 

[Rhyan]

I sort of figured that would be the way to go but the query has me stumped, not sure hwo to write it to draw records beginning with A in one table and Beginning with B in the other

Select * FROM tablename Where ??

I had thought there was a way to draw records that begin with letters, not sure though

 

[Rhyan]

I think I remembered how to do it finally!!!

SELECT * FROM pet WHERE name LIKE &quot;b%&quot;;