Display Results Horizontally

jsantama

Hi there,

I'm trying to display results in a table. But here is the catch. I can get the results I want, but it displays them vertically, as such:

<table width="240" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="113" class="pp_subheading">Data</td>
	<td width="120">2003-04-30 00:00:00</td>
  </tr>
  <tr>
    <td width="113">Weight</td>
	<td width="120">252.00</td>
  </tr>
  <tr>
    <td width="113">Waist</td>
	<td width="120">47.00</td>
  </tr>
  <tr>
    <td width="113">Chest</td>
	<td width="120">46.50</td>
  </tr>
  <tr>
    <td width="113">Forearm</td>
	<td width="120">12.25</td>
  </tr>
  <tr>
    <td width="113">Biceps</td>
	<td width="120">16.25</td>
  </tr>
  <tr>
    <td width="113">Thighs</td>
	<td width="120">26.00</td>
  </tr>
  <tr>
    <td width="113">Calves</td>
	<td width="120">16.50</td>
  </tr>
  <tr>
    <td width="113">Hips</td>
	<td width="120">46.00</td>
  </tr>
  <tr>
    <td width="113">Wrist</td>
	<td width="120">7.00</td>
  </tr>

</table>
<table width="240" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="113" class="pp_subheading">Data</td>
	<td width="120">2003-04-30 00:00:00</td>
  </tr>
  <tr>
    <td width="113">Weight</td>
	<td width="120">250.00</td>
  </tr>
  <tr>
    <td width="113">Waist</td>
	<td width="120">0.00</td>
  </tr>
  <tr>
    <td width="113">Chest</td>
	<td width="120">0.00</td>
  </tr>
  <tr>
    <td width="113">Forearm</td>
	<td width="120">0.00</td>
  </tr>
  <tr>
    <td width="113">Biceps</td>
	<td width="120">0.00</td>
  </tr>
  <tr>
    <td width="113">Thighs</td>
	<td width="120">0.00</td>
  </tr>
  <tr>
    <td width="113">Calves</td>
	<td width="120">0.00</td>
  </tr>
  <tr>
    <td width="113">Hips</td>
	<td width="120">0.00</td>
  </tr>
  <tr>
    <td width="113">Wrist</td>
	<td width="120">0.00</td>
  </tr>

</table>

but I dont' want my results to create a second, third.... table... I want them to fill accross 1 table like this:

<table width="240" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="113" class="pp_subheading">Data</td>
	<td width="120">Date 1</td>
	<td width="120">Date 2</td>
  </tr>
  <tr>
    <td width="113">Weight</td>
	<td width="120">252.00</td>
	<td width="120">250.00</td>
  </tr>
  <tr>
    <td width="113">Waist</td>
	<td width="120">47.00</td>
	<td width="120">0</td>
  </tr>
  <tr>
    <td width="113">Chest</td>
	<td width="120">46.50</td>
	<td width="120">0</td>
  </tr>
  <tr>
    <td width="113">Forearm</td>
	<td width="120">12.25</td>
	<td width="120">0</td>
  </tr>
  <tr>
    <td width="113">Biceps</td>
	<td width="120">16.25</td>
	<td width="120">0</td>
  </tr>
  <tr>
    <td width="113">Thighs</td>
	<td width="120">26.00</td>
	<td width="120">0</td>
  </tr>
  <tr>
    <td width="113">Calves</td>
	<td width="120">16.50</td>
	<td width="120">0</td>
  </tr>
  <tr>
    <td width="113">Hips</td>
	<td width="120">46.00</td>
	<td width="120">0</td>
  </tr>
  <tr>
    <td width="113">Wrist</td>
	<td width="120">7.00</td>
	<td width="120">0</td>
  </tr>

</table>

Any ideas?
Here is my php code

<?php
.........
$base_query="select * from $TableName where user_ID='$user_ID'";
$base_query= stripSlashes($base_query);
$base_result= mysql_query($base_query);
//$base_data = mysql_fetch_array($base_result);
while ($base_data = mysql_fetch_array ($base_result)) {

?>
<table width="240" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="113" class="pp_subheading">Data</td>
	<?php echo"<td width=\"120\">$base_data[Date]</td>\n";?>
  </tr>
  <tr>
    <td width="113">Weight</td>
	<?php echo"<td width=\"120\">$base_data[Weight]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Waist</td>
	<?php echo"<td width=\"120\">$base_data[Waist]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Chest</td>
	<?php echo"<td width=\"120\">$base_data[Chest]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Forearm</td>
	<?php echo"<td width=\"120\">$base_data[Forearm]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Biceps</td>
	<?php echo"<td width=\"120\">$base_data[Biceps]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Thighs</td>
	<?php echo"<td width=\"120\">$base_data[Thighs]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Calves</td>
	<?php echo"<td width=\"120\">$base_data[Calves]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Hips</td>
	<?php echo"<td width=\"120\">$base_data[Hips]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Wrist</td>
	<?php echo"<td width=\"120\">$base_data[Wrist]</td>\n"?>
  </tr>

</table>
<?php
}
?>

Thanks

wreed

Sounds like its looping through and just creating the table twice, maybe try it like this...


<table width="240" border="1" cellspacing="0" cellpadding="0">
<?php
.........
$base_query="select * from $TableName where user_ID='$user_ID'";
$base_query= stripSlashes($base_query);
$base_result= mysql_query($base_query);
//$base_data = mysql_fetch_array($base_result);
while ($base_data = mysql_fetch_array ($base_result)) {

?>

  <tr>
    <td width="113" class="pp_subheading">Data</td>
    <?php echo"<td width=\"120\">$base_data[Date]</td>\n";?>
  </tr>
  <tr>
    <td width="113">Weight</td>
    <?php echo"<td width=\"120\">$base_data[Weight]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Waist</td>
    <?php echo"<td width=\"120\">$base_data[Waist]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Chest</td>
    <?php echo"<td width=\"120\">$base_data[Chest]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Forearm</td>
    <?php echo"<td width=\"120\">$base_data[Forearm]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Biceps</td>
    <?php echo"<td width=\"120\">$base_data[Biceps]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Thighs</td>
    <?php echo"<td width=\"120\">$base_data[Thighs]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Calves</td>
    <?php echo"<td width=\"120\">$base_data[Calves]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Hips</td>
    <?php echo"<td width=\"120\">$base_data[Hips]</td>\n"?>
  </tr>
  <tr>
    <td width="113">Wrist</td>
    <?php echo"<td width=\"120\">$base_data[Wrist]</td>\n"?>
  </tr>


<?php
}
?>
</table>

wreed

YOu are gonna have to rewrite your code cause it will print the first column twice, the description of the row....the reason it was doing 2 tables was cause you had the whole table tag in the loop.

jsantama

wreed,

Thanks for that. I should have gotten that one!! Now for the main question, would you have any idea how to display horizontally, not vertically?
I have google it, I have searched everywhere but to no avail.
Any takers????

wreed

Do one table that would be teh row information, then another table that would do the loop and pull information from the db.

toma42

Here's code to do it in smarty assuming $data is a multidimentional array with all your data in it

<table>
<tr><th>Weight</th><th>Waist</th></tr>

<tr>
{foreach from=$data item=d}
<td>{$d.weight}</td>
{/foreach}
</tr>

<tr>
{foreach from=$data item=d}
<td>{$d.waist}</td>
{/foreach}
</tr>
</table>

jsantama

wreed, toma42...
Thanks a lot for you help.
Now, for toma42's advice.... my array is

$base_data = mysql_fetch_array ($base_result)

is that a multidimentional array? if so... I would replace $data with $base_data right?
Do I want to have:

<?php
<tr> 
{foreach from=$data item=d} 
<td>{$d.weight}</td> 
{/foreach} 
</tr>
?>

echoing or printing out the table or how would you implement it?
Thanks for the patience...

toma42

The example I gave uses smarty (smarty.php.net).

In english: put all column data into a multi dimentional array and iterate through this array for each row, echoing out only the column you want displed.