1 ORDER BY PJ.timeofday
DESC, '# of attempts' DESC";
$result = mysql_query( $q, $conn );
if( !$result )
{
echo "Failed to query database :(";
exit();
}
if( !mysql_num_rows($result) )
{
echo "Bummer. No records found.";
exit();
}
echo "\n";
echo "\n";
$idcol = -1;
$cnt = 0;
while( $cnt".mysql_fieldname($result,$cnt)."\n";
$cnt++;
}
echo "
\n";
$nf = mysql_num_fields($result);
while( ($row=mysql_fetch_row($result)) )
{
echo "\n";
$fcnt = 0;
while( $fcnt<$nf )
{
if( $fcnt!=$idcol )
{
echo " | ".$row[$fcnt]." | \n";
}
$fcnt++;
continue;
}
echo "
\n";
}
?>