Jump to content

[SOLVED] Help with echo


tqla

Recommended Posts

Hi. I am using this code to echo a column in my database. It works fine:

   while ($list = mysql_fetch_array($result)) {
      echo "{$list['CompanyName']} <br>";
   }

 

I would like to add another column to it. I've tried doing this but I get parse errors: {$list['CompanyName','email']}

 

How do I add more columns to the while statement? Ultimately I'd like the echo to print out 6 columns per row from the DB.

 

Thanks!

Link to comment
https://forums.phpfreaks.com/topic/62563-solved-help-with-echo/
Share on other sites

You can specify the column like so:

 

while ($list = mysql_fetch_array($result)) {
    echo $list['CompanyName'] . "<br />";
    echo $list['anotherColumnName'] . "<br />";
}

 

Or echo all of them like :

 

while ($list = mysql_fetch_assoc($result)) {
    foreach ($list as $key => $value) {
        echo $key . " = " . $value;
    }
}

Link to comment
https://forums.phpfreaks.com/topic/62563-solved-help-with-echo/#findComment-311398
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.