You have alot of unclosed tags in there ... Let me help you out a bit and pastebin how it should look!...
This should help http://pastie.org/759936 On Dec 28, 6:44 pm, ace123 <markay...@gmail.com> wrote: > I'm not sure if this is possible...but I love the jquery tablesorter- > but I can't figure out how to get it working. My page displays as if > it's not even there. I used php to snmpget some data from my network > switches and routers. It saves it to my DB...then I have this page to > display the information from the database. This is where I want to be > able to sort, by switch type, software version, etc. I'm not a code > guy, just a network engineer trying to make my job easier. Your help > please is MUCHHHHHHHHH appreciated. I've been trying to get this to > work off and on for 6 months. > > This is what I've got so far.... > > The page looks something like this when I load it. > > Host Name Device Type Firmware Version Software Version > > edge-109c-gs.gov.ntwk 470-24T "3.6.0.7" "v3.7.3.13" > edge-241c-gs.anx.ntwk 470-24T "3.6.0.7" "v3.7.3.13" > edge-399c-gs.anx.ntwk 470-24T "3.6.0.7" "v3.7.3.13" > > <html> > <body> > > <?php > $username="root"; > $password=""; > $database="switchesdb"; > mysql_connect(localhost,$username,$password); > mysql_select_db($database) or die( "Unable to select database"); > $query="SELECT * FROM switchcode"; > $result=mysql_query($query); > $num=mysql_numrows($result); > ?> > > <head> > <script type="text/javascript" src="/var/www/html/jquery-1.3.2.js"></ > script> > <script type="text/javascript" src="/var/www/html/ > jquery.tablesorter.min.js"></script> > <script type="text/javascript" > $(document).ready(function() { > // call the tablesorter plugin > $("table").tablesorter({ > // enable debug mode > debug: true > }); > > });</script> > > <table id="table"> > <table class="tablesorter" cellspacing="1"> > <thead> > <table border="1" cellspacing="4" cellpadding="4"> > <tr> > <th><font face="Arial, Helvetica, sans-serif">Host Name</font></th> > <th><font face="Arial, Helvetica, sans-serif">Device Type</font></th> > <th><font face="Arial, Helvetica, sans-serif">Firmware Version</font></ > th> > <th><font face="Arial, Helvetica, sans-serif">Software Version</font></ > th> > </tr> > </thead> > </head> > <?php > $i=0; > while ($i < $num) { > $host_name=mysql_result($result,$i,"host_name"); > $device_type=mysql_result($result,$i,"device_type"); > $firmware_version=mysql_result($result,$i,"firmware_version"); > $software_version=mysql_result($result,$i,"software_version"); > ?> > > <tbody> > <tr> > <td><font face="Arial, Helvetica, sans-serif"><?php echo $host_name; > ?></font></td> > > <td><font face="Arial, Helvetica, sans-serif"><?php echo > $device_type; ?></font></td> > <td><font face="Arial, Helvetica, sans-serif"><?php $cleanstring > =strstr($firmware_version, "\""); echo ($cleanstring); ?></font></td> > <td><font face="Arial, Helvetica, sans-serif"><?php $cleanstring1 > =strstr($software_version, "\""); echo ($cleanstring1); ?></font></td> > </tr> > </tbody> > </body> > </html> > > <?php > $i++;} > > ?>
