[RESOLVED] Listing table contents

Jon12345

I have the contents of a table that I would like listed. The fields should be in a column with headings.

Currently I have:

$query = mysql_query("SELECT Date, Time, Keyword, Position FROM logfile");
while ($row = mysql_fetch_array($query)) {
    echo "<td><span class='style3b'>$row</span></td>\n";

  echo "</tr>\n";
}

But I am not getting the output I hoped.

Can someone help me?

leatherback

echo "<table>
<tr>
<td>add</td>
<td>colum</td>
<td>head</td>
<td>here</td>
</tr>";

$query = mysql_query("SELECT Date, Time, Keyword, Position FROM logfile");
while ($row = mysql_fetch_array($query)) {
    echo "
<tr>
<td><span class='style3b'>$row[Date]</span></td>
<td><span class='style3b'>$row[Time]</span></td>
<td><span class='style3b'>$row[Keyword]</span></td>
<td><span class='style3b'>$row[Position]</span></td>
</tr>";
}

echo "</table>";

Jon12345

Oh wow that works! 😃

I also want it sorted by Date then Time. I have done it by date (see below) but how do I also do it by date first then time as the secondary sort?

$query = mysql_query("SELECT Date, Time, Keyword, Position FROM logfile ORDER BY 'date' DESC");

leatherback

Hi,

You should store your date & time in one field, type: timestamp. Makes life easier on the long run. That would also automatically sort correctly when sorting the datetime field.

Jon12345

Ok, good point. Unfortunately, I have no say over the database structure and there is a lot of historical data. Is there an easy way to sort by both fields if they are seperated out?

leatherback

Yes.

Just add order by date, time at the end of the query.

Jon12345

All working now, thanks!