# Mysql Problems/Array?

**URL:** <https://forum.kirupa.com/t/mysql-problems-array/75869>\
**Category:** Uncategorized\
**Created:** [January 12, 2005, 8:57pm UTC](https://forum.kirupa.com/t/mysql-problems-array/75869 "2005-01-12T20:57:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fact](https://avatars.discourse-cdn.com/v4/letter/f/a183cd/32.png) [@Fact](https://forum.kirupa.com/u/Fact)\
**Post date:** [January 12, 2005, 8:57pm UTC](https://forum.kirupa.com/t/mysql-problems-array/75869/1 "2005-01-12T20:57:29Z")

</div>

```php
 
 
<?php
if(session_id() != True) { die("No Direct File Viewing"); }
if( SESSION['ADMIN'] == '1') {
 
$query = "SELECT ip,browser FROM CJ_UsersOnline";
$result = mysql_query ($query)
or die ("Query failed");
echo "<table width=406 cellspacing=0 cellpadding=0 border=1 bordercolor=#FFFFFF>";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach($line as $vark) {
$ip = $line['ip'];
$browser = $line['browser'];
?>
<tr><td onmouseover="this.borderColor='#000000'" onmouseout="this.borderColor='#FFFFFF'"><p><?php echo $ip; ?>:<?php echo $browser; ?></td></tr>
<?php
}
}
echo "</table>";
} else { Echo "You need to be logged in as admin"; }
?>
 

```

ive edited an Online users script to add there browser and ip

and that code should repeat the results once but it does it twice ☹ help plz