PHP-MySQL Select DISTINCT as PHP ARRAY. 1

[bigdog619sd]

Hello, I am trying to pull DISTINCT data from a MySQL DataBase and feed it into a php array.

Here is the query.
$DistinctServersFromDB = "SELECT DISTINCT Name FROM Server_Monitor ";
$result4 = mysql_query($DistinctServersFromDB) or die ("Query failed: " . mysql_error());
for ($i = mysql_num_rows($result4) - 1; $i >= 0; $i--) {
if (!mysql_data_seek($result4, $i)) {
echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue ; }
if(!($row = mysql_fetch_object($result4))) continue ;
$q4Name = $row->Name ;
echo &quot; $q4Name <br> &quot; ; }


How can I get the data from this query into an array ?
If there is a more elegant way to do this please let me know.

Thanks for all your help...
dhaynes

 

[Westbury]

mysql_fetch_array() will do the trick for you

Example code from the manual:

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
        printf ("ID: %s  Name: %s", $row[0], $row[1]);  
}

You can also get it to create an associative array:

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
        printf ("ID: %s  Name: %s", $row["id"], $row["name"]);
    }

Both these will loop around for each row returned.

 

[bigdog619sd]

Associative array was ticket.
Thank you much
Bigdog...