How to create an array of columns from a database result?

[nasse]

Would you please help me in how to get the remaining column values so that I will be able to echo each value in my pages. Right now, my function is set to return just to return one field's value (line 13) but I want to do the same for all the remaining fields. How do I write loopings like foreach ....

class Setting extends Domain
{
  function __construct()
  {
    parent::__construct( 'Settings', array 'Settings_id', 'webSite', 'Slogan', 'Title'));
  }
  function Sett()
   {
    global $db;
    $SS = $db->query('SELECT * FROM Settings where webSite = "'.$this->domain().'"');
    while ($SS->fetchInto($row, DB_FETCHMODE_ASSOC)) {
      return $row[webSite];
    }
  }
}
 
$Set = new Setting();
echo $Set->Sett($row[webSite]);
 

[Atli]

Hi.

Please post your code inside [code] tags! It is almost impossible to read without them.

Also, please give your threads descriptive titles. They help our other members finding threads they are likely to be able to help with, thus increasing your chances of getting an answer.

All this, and more, can be read in the Posting guidelines, which all members are required to follow.

Thank you :)

As to your question.

Not knowing exactly which database system you are using, or even how your class handles the database results, I will assume you are using MySQL.

Try something like:

$result = mysql_query("SELECT * FROM tbl");
while($row = mysql_fetch_assoc($result)) {
  $data[] = $row
}
return $data;
 

[nasse]

Hi, thank you for the help very much. When I tried that, I get array output. When I tried this:

[PHP] $data[] = $row;[/PHP]
[PHP] foreach ($row as $data) {return $data;}[/PHP]

I get the value of the first field. So how do I print the values for the remaining fields from this code. Any idea?

Hi.

Please post your code inside [code] tags! It is almost impossible to read without them.

Also, please give your threads descriptive titles. They help our other members finding threads they are likely to be able to help with, thus increasing your chances of getting an answer.

All this, and more, can be read in the Posting guidelines, which all members are required to follow.

Thank you :)

As to your question.

Not knowing exactly which database system you are using, or even how your class handles the database results, I will assume you are using MySQL.

Try something like:

$result = mysql_query("SELECT * FROM tbl");
while($row = mysql_fetch_assoc($result)) {
  $data[] = $row
  return $data;
}
 

[Atli]

I'm afraid I made a small error in my previous post. I put the return keyword inside the while loop, which will of course only return the first row of data. I've fixed my previous post.

As to your problem, I think you may be misunderstanding how the return keyword works.
Once you call the return keyword, the function is immediately terminated, returning the value you specify.

So, calling return inside any loop will always terminate the loop and it's parent function on it's first run. In your case, this will always leave you with a single field or row, depending on your code.

Consider this code. It will simply print all fields of all rows:

$result = mysql_query("SELECT * FROM tbl");
$rowIndex = 0;
while($row = mysql_fetch_assoc($result)) {
  echo "Row {$rowIndex}: <br />";
  foreach($row as $_key => $_value) {
    echo "  - {$_key} = {$_value}";
  }
}