tqla Posted July 30, 2007 Share Posted July 30, 2007 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 More sharing options...
DeepakJ Posted July 30, 2007 Share Posted July 30, 2007 while ($list = mysql_fetch_array($result)) { echo $list['CompanyName']."<br>"; } try Link to comment https://forums.phpfreaks.com/topic/62563-solved-help-with-echo/#findComment-311393 Share on other sites More sharing options...
calabiyau Posted July 30, 2007 Share Posted July 30, 2007 echo $list['companyname']."<br/>".$list['yournextcolumn']."<br/>".$list['the_next_column'].....etc['code] Link to comment https://forums.phpfreaks.com/topic/62563-solved-help-with-echo/#findComment-311395 Share on other sites More sharing options...
teng84 Posted July 30, 2007 Share Posted July 30, 2007 while ($list = mysql_fetch_array($result)) { echo $list['CompanyName']."<br>"; echo $list['email']."<br>"; } or while ($list = mysql_fetch_array($result)) { echo $list['CompanyName']."".$list['email']; } Link to comment https://forums.phpfreaks.com/topic/62563-solved-help-with-echo/#findComment-311396 Share on other sites More sharing options...
hitman6003 Posted July 30, 2007 Share Posted July 30, 2007 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 More sharing options...
tqla Posted July 30, 2007 Author Share Posted July 30, 2007 Thank you everybody. They all work perfectly. Link to comment https://forums.phpfreaks.com/topic/62563-solved-help-with-echo/#findComment-311452 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.