I believe your best bet is to change how you are iterating through the $row
data.
Since there are only 6 columns of data, I think the simplest solution is to
remove the foreach() and handle each column's data independently, ie:
while($row = mysql_fetch_row($result10))
{
print '
<tr>
<td>' . $row['first_column'] . '</td>
<td>' . $row['second_column'] . '</td>
<td>' . $row['third_column']/60 . '</td>
<td>' . $row['fourth_column'] . '</td>
<td>' . $row['fifth_column'] . '</td>
<td>' . $row['sixth_column'] . '</td>
</tr>';
}
Thanks
patrick
On Wed, Jul 15, 2009 at 1:10 PM, Don Collier <don@xxxxxxxxxxxxxxx> wrote:
> 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
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
