Hi. I have a script that is working but I need to be able to sort by different "fields". For example, I want to sort by date or by name. The file is a .dat file, created by another program, which is delimited by "|". There are no fields per se, so I need to create them and sort by them. Ideas? Thanks.
<?php
$fd = fopen("bobby.dat", "r")
or die("couldnt open csv file");
$str=fgets($fd); // skips the header
while (!feof($fd)) {
$str = trim(fgets($fd));
if ($str == "")
continue;
$vals = explode("|", $str);
$vals[6] = str_replace(":",".",$vals[6]);
$vals[5] = str_replace(":",".",$vals[5]);
$avghits = ( $vals[6] - $vals[5] );
$avghits = number_format($avghits, 1, '.', ' ');
?>
<table border="0" cellspacing="0" cellpadding="4" width="100%">
<tr><td colspan="5"><font face="tahoma" size="3"><?= $vals[0] ?></font><br></td></tr>
<tr>
<td width="50" align="left" bgcolor="#cccccc" style="border: 1 solid #cccccc"><font face="verdana" size="1">Date</font></td>
<td width="250" align="left" bgcolor="#cccccc" style="border: 1 solid #cccccc"><font face="verdana" size="1">Project</font></td>
<td width="250" align="left" bgcolor="#cccccc" style="border: 1 solid #cccccc"><font face="verdana" size="1">Task</font></td>
<td width="150" align="left" bgcolor="#cccccc" style="border: 1 solid #cccccc"><font face="verdana" size="1">Comments</font></td>
<td width="80" align="left" bgcolor="#cccccc" style="border: 1 solid #cccccc"><font face="verdana" size="1">Total</font></td>
<tr>
<td width="50" align="left" bgcolor="#ffffcc" ><font face="verdana" size="2"><?= $vals[1] ?></font></td>
<td width="250" align="left" bgcolor="#99cc99" ><font face="verdana" size="2"><?= $vals[2] ?></font></td>
<td width="250" align="left" bgcolor="#cccc99" ><font face="verdana" size="2"><?= $vals[3] ?></font></td>
<td width="150" align="left" bgcolor="#ff6633" ><font face="verdana" size="2"><?= $vals[4] ?></font></td>
<td width="80" align="left" bgcolor="#339900" ><font face="verdana" size="2"><?= $avghits ?> Hours</font></td>
</tr>
<?php
}
