Making dynamic table sortable

[Ian Rastall]

I'm doing a small project right now where I create a table from a
database. This is the code, which Dreamweaver, for the most part,
has written:

***

<?php
mysql_select_db ($database_tdre am, $tdream);
$query_rstdream = "SELECT * FROM albums ORDER BY `year` ASC";
$rstdream = mysql_query($qu ery_rstdream, $tdream) or die
(mysql_error()) ;
$row_rstdream = mysql_fetch_ass oc($rstdream);
$totalRows_rstd ream = mysql_num_rows( $rstdream);
?>

***

<table cellspacing="0" >
<thead>
<tr>
<td>Album</td>
<td>Year</td>
<td>Era</td>
<td>Type</td>
</tr>
</thead>
<tbody>
<?php do { ?>
<?php
$class = ($class == 'odd') ? 'even' : 'odd';
?>
<tr class="<?php echo $class ?>">
<td><?php echo $row_rstdream['Name']; ?></td>
<td><?php echo $row_rstdream['Year']; ?></td>
<td><?php echo $row_rstdream['Era']; ?></td>
<td><?php echo $row_rstdream['Type']; ?></td>
</tr>
<?php } while ($row_rstdream = mysql_fetch_ass oc($rstdream));
?>
</tbody>
</table>

***

Sorry for the length of the examples. I have a basic
understanding of what the code is doing, so I should be able to
modify it if I knew I was heading in the right direction. My
object is to make this table sortable, by clicking on the column
headers. I have an additional column in my database table which
is an auto_increment counter. Would anyone have some ideas or
code that could help me figure this out? I'm not sure how to
approach it, and was hoping that there was a simple answer to the
problem.

TIA
Ian
--
http://www.bookstacks.org/

[Ian Rastall]

In comp.lang.php Geoff Berrow wrote:

Add (at the top)

$order=$_GET['order'];

Woo-hoo! Thank you, that worked just fine. Now I think I've finally
got this part of the page done.

--
Ian

http://www.bookstacks.org/

[Positive Contrarian]

I dunno whetrher you've considered this and rejected it, but there're a
number of free client-side JS scrpts that do the sort, alternating
directions too, completely client-side, and handling strings, numerics,
dates.

Google for "sorttable. js" . I'm using it for 150-row datasets, and
getting nice performance on a dinky machine in a number of app's.
Piece of cake!

[Ian Rastall]

In comp.lang.php Positive Contrarian wrote:

Google for "sorttable. js" .

That's what I was using before, actually. I want to make
everything PHP now, as that's what I'm learning. Also, the JS
sort table didn't do secondary sorts. For instance, in this table
there are a number of times when more than one album comes out in
the same year. In order to get the JS to sort correctly, I would
add little sort characters, like "a" "b" "c" etc., to the title
and make it invisible through display: none. At least with the
PHP that's done for me, since I enter them into the database in
order, and can sort by both, say, "Year" and "ID".

If you're using zebra rows in your JS sort table, you might try
using the PHP line that I found somewhere and added in:

<?php
$class = ($class == 'odd') ? 'even' : 'odd';
?>
<tr class="<?php echo $class ?>">

then all you need is the CSS class for .even and you're set.

Ian
--
http://www.bookstacks.org/

[Tony Marston]

Have a look at
http://www.tonymarston.co.uk/php-mys...faq.html#faq07 to see
how I have implemented column sorting without using javascript.

--
Tony Marston

http://www.tonymarston.net
"Ian Rastall" <id*******@gmai l.com> wrote in message
news:Xn******** *************** ****@130.133.1. 4...

In comp.lang.php Positive Contrarian wrote:

Google for "sorttable. js" .

That's what I was using before, actually. I want to make
everything PHP now, as that's what I'm learning. Also, the JS
sort table didn't do secondary sorts. For instance, in this table
there are a number of times when more than one album comes out in
the same year. In order to get the JS to sort correctly, I would
add little sort characters, like "a" "b" "c" etc., to the title
and make it invisible through display: none. At least with the
PHP that's done for me, since I enter them into the database in
order, and can sort by both, say, "Year" and "ID".

If you're using zebra rows in your JS sort table, you might try
using the PHP line that I found somewhere and added in:

<?php
$class = ($class == 'odd') ? 'even' : 'odd';
?>
<tr class="<?php echo $class ?>">

then all you need is the CSS class for .even and you're set.

Ian
--
http://www.bookstacks.org/

[Geoff Berrow]

I noticed that Message-ID: <Xn************ *************** @130.133.1.4>
from Ian Rastall contained the following:

If you're using zebra rows in your JS sort table, you might try
using the PHP line that I found somewhere and added in:

<?php
$class = ($class == 'odd') ? 'even' : 'odd';

Ahh... I'd spotted that and didn't think it looked like Dreamweaver
generated code. Nice.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/