highlighting a selected column

[kimrari]

hi all,

i tried searching the forum first before posting, but i couldnt find the answer. i think i might not have been using the best word.

i have a php script that querys a mysql database, and is also sortable. what i would like, is when u click on a column to sort, the column hilights. how do i go about doing that?

my code is:

<><>
<?php
mysql_connect( 'localhost', 'username', 'password' ) or die ( 'Unable to
connect.' );
mysql_select_db( 'tortl' ) or die ( 'Unable to select database.' );

// if $sortby isn't empty, then check to see which column we're sorting by
if( $sortby != "" ){
switch( $sortby ){
case "col1": $sql = "SELECT FROM players ORDER BY id"; // sorts by column1
break;
case "col2": $sql = "SELECT FROM players ORDER BY name"; //
break;
case "col3": $sql = "SELECT FROM players ORDER BY team";
break;
case "col4": $sql = "SELECT FROM players ORDER BY rs";
break;
case "col5": $sql = "SELECT FROM players ORDER BY rp";
break;
case "col6": $sql = "SELECT FROM players ORDER BY ms";
break;
case "col7": $sql = "SELECT FROM players ORDER BY hp";
break;
case "col8": $sql = "SELECT FROM players ORDER BY ps";
break;
case "col9": $sql = "SELECT FROM players ORDER BY pc";
break;
case "col10": $sql = "SELECT FROM players ORDER BY pa";
break;
case "col11": $sql = "SELECT FROM players ORDER BY afb DESC";
break;
case "col12": $sql = "SELECT FROM players ORDER BY picture";
// etc.
default: $sql = "SELECT FROM players"; // if $sortby isn't one of our values don't sort
}
}
// otherwise, don't sort
else {
$sql = "SELECT FROM players";
}

$result = mysql_query( $sql ) or die ( 'Unable to execute query.' );
?>

<table border="1">
<tr>
<th><a href="roster.php?sortby=col1">id</a></th>
<th><a href="roster.php?sortby=col2">name</a></th>
<th><a href="roster.php?sortby=col3">team</a></th>
<th><a href="roster.php?sortby=col4">rs</a></th>
<th><a href="roster.php?sortby=col5">rp</a></th>
<th><a href="roster.php?sortby=col6">ms</a></th>
<th><a href="roster.php?sortby=col7">hp</a></th>
<th><a href="roster.php?sortby=col8">ps</a></th>
<th><a href="roster.php?sortby=col9">pc</a></th>
<th><a href="roster.php?sortby=col10">pa</a></th>
<th><a href="roster.php?sortby=col11">avoid block</a></th>
<th><a href="roster.php?sortby=col12">picture</a></th>
</tr>
<?php
while($row = mysql_fetch_array($result)){
?>
<tr>
<td><?=$row[0]?></td>
<td><?=$row[1]?></td>
<td><?=$row[2]?></td>
<td><?=$row[3]?></td>
<td><?=$row[4]?></td>
<td><?=$row[5]?></td>
<td><?=$row[6]?></td>
<td><?=$row[7]?></td>
<td><?=$row[8]?></td>
<td><?=$row[9]?></td>
<td><?=$row[10]?></td>
<td><?=$row[11]?></td>
</tr>
<?php
}
?>
</table>

<><>

and u can see it in action at:

http://tortl.tecmobowl.org/roster.php

any suggestions would be extremely helpful.

Thx in advance,

Kimrari

[mmilano]

just make if statements before the sort_by word is printed. if it is the colum that is sorted by, then print a different color font tag.

keep your sort-by section within the php tags so you can do something like this:
<?
echo "
<table border=\"1\">
<tr>
<th><a href=\"roster.php?sortby=col1\">";

if($sort_by=="col1"){
echo "<font color=red>";
}

echo "id</a></th>
<th><a href=\"roster.php?sortby=col2\">";

if($sort_by==col2){
echo "<font color=red>";
}

echo "name</a></th> ";
?>

[mmilano]

aah, that code got hosed...

this board supports font tags .. so just take the dots out of the font tags in this example.

<?
echo "
<table border=\"1\">
<tr>
<th><a href=\"roster.php?sortby=col1\">";

if($sort_by=="col1"){
echo "<.font color=red.>";
}

echo "id</a></th>
<th><a href=\"roster.php?sortby=col2\">";

if($sort_by==col2){
echo ""<.font color=red.>";
}

echo "name</a></th> ";
?>