Re: Changing part of a query before displaying it

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@collierclan.com> 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 > >