Array field display help

[BillRoberts]

Hello,
I'm still basically very new to PHP & MySQL program. The situation is that I have query running against my database that pulls out the information that I needed. I then take one of the values from the array and divide it by 60 to convert that time to minutes. What I need to know is how can I pull the field in the query that gives me the raw data, and then not display that field, but display my modified data in place of the field that is pulled from the database. Here is a code snippet of what I have. Any help would be appreaciated! Thanks in advance. Bill

foreach($row as $data)
echo "\n\t<td align=right> $data </td>"; $time = round(($row[4]/60), 2); echo "\n\t<td align=right> $time </td>";

[Mordecai]

Can you perhaps give us a print_r() of $row, so we know what you're trying to blank out?

If not, could you perhaps explain a little more in depth?

[BillRoberts]

Originally posted by BillRoberts
Hello,
I'm still basically very new to PHP & MySQL program. The situation is that I have query running against my database that pulls out the information that I needed. I then take one of the values from the array and divide it by 60 to convert that time to minutes. What I need to know is how can I pull the field in the query that gives me the raw data, and then not display that field, but display my modified data in place of the field that is pulled from the database. Here is a code snippet of what I have. Any help would be appreaciated! Thanks in advance. Bill

foreach($row as $data)
echo "\n\t<td align=right> $data </td>"; $time = round(($row[4]/60), 2); echo "\n\t<td align=right> $time </td>";

Mordecai,
Here is the information that you have requested.

Array ( [0] => 3163215850 [1] => 216.63.194.196 [2] => 2003-10-27 05:44:23 [3] => 2003-10-27 05:45:29 [4] => 67 )

anything else you need? Thanks. Bill

[dalecosp]

Hi Bill,

What you've got is fine (you can use $time in this way), except for this: when you use "foreach($row as $data)", you want to refer to $data, not $row, within the loop:

<!-- Is this a web server log, etc.??  -->
<!-- header -->

<h2>Log Information</h2>
<table>
   <th>Remote Host</th>
   <th>Initial Connect</th>
   <th>Connection terminated</th>
   <th>Connection length (minutes)</ht>

<?php
// db stuff goes here ...

// then

foreach ($row as $data) {
                  // note indices
   echo "\n\t<td align=right> $data['1'] </td>";  

   echo "\n\t<td align=right> $data['2'] </td>"; 
   echo "\n\t<td align=right> $data['3'] </td>"; 
            // here was one error, you used $row instead of $data...
   $time = round(($data['4']/60), 2);         

   echo "\n\t<td align=right> $time </td>";
}
//etc....
?>

HTH,

[BillRoberts]

dalecosp

Thanks for the solution, with hindsight being 20/20 the solution was very simple, had to modify the code a little to make it work the way I wanted, but you gave me the answer I needed. Like I said in my first post I'm still new to programming, so I'm learning as I go. Just for your info, it is a RADIUS log file that its for. I'm working on a user interface that they can log on, change passwords, check usage and so forth. Thanks again for your help. Bill

[dalecosp]

Welcome to PHPBuilder! 🙂