This is easy right? Format data output

dwhntx

I have a website that is going to display all the local bars along with thier address, phone number and drink specials. I want the bar name, address and phone number to line up verticaly and then running parallel to that I want all the drink specials also running vertically. There is going to be several bars so in between each bars information I want a line break like in the example page.

I have spent my entire weekend trying to get this layout corrent and have not had any luck, please point me in the right direction.

<? 
	include("application.php");
	include("$CFG->templatedir/header.php"); 
?> 
    <div id="main">
     <div id="rolloverbuttons">
	 <img src="images/rollover/monday.jpg"/><img src="images/rollover/tuesday.jpg"/><img src="images/rollover/wednesday.jpg"/><img src="images/rollover/thursday.jpg"/><img src="images/rollover/friday.jpg"/><img src="images/rollover/saturday.jpg"/><img src="images/rollover/sunday.jpg"/>
	 </div>
<div id="rolloverbuttonsspacer">

 </div>
<div align="center">
    <table border="0" cellspacing="0" cellpadding="0" id="table2" width="337">
      <tr> 
        <td colspan="2" align="left">

	<? 
//$sql =	"SELECT *
//	FROM bars, specials
//	INNER JOIN bars
//	ON bars.bar_id = specials.bar_id
//	WHERE specials.weekday = dayofweek()";
$today =  date("l");

$sql = "SELECT * FROM bars INNER JOIN specials ON bars.bar_id = specials.bar_id WHERE specials.weekday = '$today'";



$query = db_query($sql);
while($row = mysql_fetch_assoc($query)){
    echo $row['bar_name'].'<br />';
    echo $row['bar_bio'].'<br />';
	echo $row['bar_phone_number'].'<br />';
	echo $row['bar_address'].'<br />';
	echo $row['special_text'].'<br />';
	echo '<hr>';
}
?>


	</td>
  </tr>
</table>

</div>
	  </div>

<? include("$CFG->templatedir/footer.php"); ?>

Where all the data comes from is pretty obvious except for the drink specials and they come from special_text

RyanS

If I'm not mistaken, it sounds like you just need to throw a simple table in...


echo '<table>'

while($row = mysql_fetch_assoc($query)){
  echo '<tr><td>'
  echo $row['bar_name'].'<br />';
  echo $row['bar_bio'].'<br />';
  echo $row['bar_phone_number'].'<br />';
  echo $row['bar_address'] . '</td>';
  echo '<td>' . $row['special_text'] . '</td>';
  echo '<tr><td colspan="2"><hr></td></tr>';
}

echo '</table>';

dwhntx

I wish I had looked at the earlier today. I actually figured it out this evening after several hours of trial and error but I guess thats the best way to actually learn.