[SOLVED] Automatically creating array

[9three]

I'm trying to pull whatever information is in my query but I am unable to fetch the information. No errors are thrown. I am able to connect, select my database, and send querys, but not able to actually display it.

 

index.php

$connection = new mysql();
$connection->connect('localhost', 'root', '');
$connection->select('9three');
$query = "SELECT * FROM clients";
$connection->query($query);
$connection->fetcharray();
$connection->close();

 

mysql.class.php

  public function fetcharray()
  {
    $this->fetch = $this->query;
    $return = array();
    while ($field = mysql_fetch_array($this->fetch))
    {
      $return[] = $field;
    }
    return $return;

  }

 

It doesn't show anything at all.

[DarkWater]

You aren't doing anything with the data returned by fetcharray().

[9three]

return $return; ??

 

if I use echo $return; then it displays: Array

[DarkWater]

That's because you can't echo an array.  Try print_r() to view an array.

[9three]

yea print_r works just fine. but its displaying the actual array. Maybe I misdirected you, what I wanted to show my results from my loop.

[DarkWater]

Just run a simple foreach loop on the array from fetcharray() then.

[9three]

Changed the code to

 

  public function fetcharray()
  {
    while ($field = mysql_fetch_array($this->query))
    {
      $id = $field['id'];
      echo $id;
    }

  } 

 

and I pulled the information by $connection->fetcharray() because I wanted to keep the "design" part clean.