Sorry for the late response; I posted three questions regardingthe
tablesorter/zebra stripes functions, but I thought they hadn't been posted
on this forum.
Anyway, thanks for the tip, but the first one didn't work for me, and I
can't figure out how to implement the second. Can you show me how to insert
the code within my code? Thanks.
echo '<script src="'.$BaseURL.'/1A/js/jquery-1.3.1.min.js"
type="text/javascript"></script>
<script src="'.$BaseURL.'/1A/js/tablesorter/jquery.tablesorter.js"
type="text/javascript"></script>
<script language="JavaScript" type="text/JavaScript">
 $(document).ready(function()
  {
  $("#myTable").tablesorter({ widgets: [\'zebra\']} );

$("#triggerMS").click(function(){
 $("#menuMS").show();
 return false;
});
$("#menuMS").click( function(){
 $("#menuMS").hide();
 return true;
});

$("#triggerReg").click(function(){
 $("#menuReg").show();
 return false;
});
$("#menuReg").click( function(){
 $("#menuReg").hide();
 return true;
});

$("#triggerKids").click(function(){
 $("#menuKids").show();
 return false;
});
$("#menuKids").click( function(){
 $("#menuKids").hide();
 return true;
});

$("#triggerLinks").click(function(){
 $("#menuLinks").show();
 return false;
});
$("#menuLinks").click( function(){
 $("#menuLinks").hide();
 return true;
});

$("#triggerBooks").click(function(){
 $("#menuBooks").show();
 return false;
});
$("#menuBooks").click( function(){
 $("#menuBooks").hide();
 return true;
});

  }
 );
</script>';



On Thu, Apr 30, 2009 at 1:54 PM, aquaone <aqua...@gmail.com> wrote:

> There are two simple ways of fixing this: having a hidden span or similar
> element appearing within your td prior to the value or better to define your
> own parser.
>
> e.g.
>   $.tablesorter.addParser({
>     id: "commaNum",
>     is: function(s) {
>       return /^[\d-]?[\d,]*(\.\d+)?$/.test(s);
>       },
>     format: function(s) {
>       return s.replace(/,/g,'');
>       },
>     type: 'numeric'
>     });
>
> aquaone
> (yes, you could use a more precise regex...)
>
>
> On Wed, Apr 29, 2009 at 20:41, David Blomstrom 
> <david.blomst...@gmail.com>wrote:
>
>> I'm using jQuery's tablesorter.js to create tables with sortable rows. It
>> works fine on both text and numerals - but only if they have no commas. For
>> example, the following column would sort properly:
>> 2
>> 18
>> 401
>> 3
>> 15
>> But this column...
>> 1,200
>> 408
>> 26,048
>> ...would sort like this:
>> 1,200
>> 26,048
>> 408
>> Does anyone know how to fix this?
>> I'm using PHP and MySQL to derive my data from a database table, using the
>> following code:
>> $Area = number_format($row["Area"]);
>> Then I simply insert $Area in a dynamic table cell, like so...
>> <td>$Area</td>
>> I posted my JavaScript links below. Thanks for any tips!
>> * * * * *
>> <script src="http://MySite/js/jquery-1.3.1.min.js";
>> type="text/javascript"></script>
>> <script src="http://MySite/js/tablesorter/jquery.tablesorter.js";
>> type="text/javascript"></script>
>> <script language="JavaScript" type="text/JavaScript">
>>  $(document).ready(function()
>>   {
>>   $("#myTable").tablesorter({ widgets: ['zebra']} );
>>
>> $("#triggerMS").click(function(){
>>  $("#menuMS").show();
>>  return false;
>> });
>> $("#menuMS").click( function(){
>>  $("#menuMS").hide();
>>  return true;
>> });
>>
>> $("#triggerReg").click(function(){
>>  $("#menuReg").show();
>>  return false;
>> });
>> $("#menuReg").click( function(){
>>  $("#menuReg").hide();
>>  return true;
>> });
>>
>> $("#triggerKids").click(function(){
>>  $("#menuKids").show();
>>  return false;
>> });
>> $("#menuKids").click( function(){
>>  $("#menuKids").hide();
>>  return true;
>> });
>>
>> $("#triggerLinks").click(function(){
>>  $("#menuLinks").show();
>>  return false;
>> });
>> $("#menuLinks").click( function(){
>>  $("#menuLinks").hide();
>>  return true;
>> });
>>
>> $("#triggerBooks").click(function(){
>>  $("#menuBooks").show();
>>  return false;
>> });
>> $("#menuBooks").click( function(){
>>  $("#menuBooks").hide();
>>  return true;
>> });
>>
>>   }
>>  );
>> </script>
>>
>> --
>> David Blomstrom
>> Writer & Web Designer (Mac, M$ & Linux)
>> www.geobop.org
>>
>
>


-- 
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

Reply via email to