Recordset Array

[Dubya008]

I don't know if this is the correct Forum to post  this under but I'm trying to fill the values of a recordset into an array. Here is what I have but it doens't work so far.

 

function fetch($info) {
        return mysql_fetch_array($info);
   }

$Proddb = new mysql;
$Proddb->connect();

$result = $Proddb->query("SELECT * FROM Colors WHERE id = '1'");
$row = $Proddb->fetch($result)
foreach ($row as $value)
{
     echo $value. "<br>";
}
$Proddb-> close();

 

The array is outputting everything twice does anyone know why?

[mikosiko]

here is why http://www.php.net/manual/en/function.mysql-fetch-array.php  read the paragraph "Return Values"

 

you can change

 

     

 return mysql_fetch_array($info)

 

for

return mysql_fetch_array($info, MYSQL_ASSOC);

 

or

return mysql_fetch_array($info, MYSQL_NUM

);

[jcbones]

Or, just call:

 

mysql_fetch_assoc($info);
//or
mysql_fetch_row($info);