Changing part of a query before displaying it
| From: | Don Collier | Date: | Wed, 15 Jul 2009 17:10:43 +0000 |
| Subject: | Changing part of a query before displaying it | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46310@lists.php.net to get a copy of this message | ||
I am quite new at this so please bare with me.
I am getting a several rows of data from a database to display in a table. One of the fields is in a format that I want to change before putting it in the table. The field is time in seconds, but I want it to be displayed in minutes instead. Below is what I have to get the data into the table.
while ($row = mysql_fetch_row($result10)) {
print '<tr>';
foreach($row as $data) {
print "<td> {$data} </td>";
}
print '</tr>';
There are 6 columns in the table and the column that I want to change is the 3rd one.
How do I go about doing this?
Don Collier