[RESOLVED] rows in loop

benracer

how can i display the 2nd row in the loop horizontal?

<table width="100%" cellspacing="1">
<?php
while($rows=mysql_fetch_array($result)){ ?>
	<td valign="bottom"><img src="../images/bar.jpg"  width="30" height="<?php echo $rows['views']; ?>"  /><</td>
	<tr><td><?php echo $rows['views']; ?></td></tr>	
<?php } ?>
</table>

mikawhat

i don't know if this is what you actually asking for...

<table width="100%" cellspacing="1"><tr> 
<?php 
$i=0;
while($rows=mysql_fetch_array($result)){ ?> 
    <td valign="bottom"><?=$rows['views']?></td> 
<?php
    if ($i == 1) {
     echo "</tr><tr>";
     $i=0;
   } else {
     $i++;
   }
?>
<?php } ?> 
</tr></table>

if it doesn't work try changing $i == 1 to 2

TheDefender

Sorry, but it's not exactly clear what you are wanting to do based on your question and provided code. I'm not sure, but it sounds like this is what you are asking for... ?!?

<table width="100%" cellspacing="1"> 
<?php 
while($rows=mysql_fetch_array($result)){ 
?> 
<tr>
     <td valign="bottom"><img src="../images/bar.jpg"  width="30" height="<?php echo $rows['views']; ?>"  /></td> 
     <td><?php echo $rows['views']; ?></td>
</tr>     

<?php
}
?> 
</table>

benracer

i have created a simple graph with barcharts - see here http://www.phpbuilder.com/board/showthread.php?t=10349373

now i have my bars displaying correct though i would like to have the views value displayed below the bar..

with this code...

<table width="100%" cellspacing="1">
<?php
while($rows=mysql_fetch_array($result)){ ?>
	<td valign="bottom"><img src="../images/bar.jpg"  width="30" height="<?php echo $rows['views']; ?>"  /></td>
	<tr><td><?php echo $rows['id']; ?></td></tr>
<?php } ?>
</table>

produces the graph with the value below, this is fine but the when it is looped the tables are below each other instead of side by side.

TheDefender

OK, I see what you want now... Sorry, but it just wasn't clear without the details fo the image or added thread...

Personally.... I would dump the values into an array. Then, I would cycle through array in one row to output the graph images.

Then I would cycle through the array again to create the second row below that one that outputs the numbers...

Something like this.
This is all conceptual and untested because I am not at home with my PHP, but should help point you on your way...

NOTE You need to modify this to complete things like your img tag and whatnot. I quickly put this all together for concept only and not for complete functionality.

while($rows=mysql_fetch_array($result)){ 
     $myarray($rows['id']) = $rows['views'];
}
echo '<table>';

echo '<tr>';
foreach($myarray as $k=>$v) {
     echo '<td><img src.... height="$v"></td>';
}
echo '</tr>';

echo '<tr>';
foreach($myarray as $k=>$v) {
     echo '<td>$k</td>';
}
echo '</tr>';

echo '</table>';

benracer

thanks, i now get this error...

Fatal error: Can't use function return value in write context in /mounted-storage/home43c/sub002/sc32535-PERI/btronics.co.uk/admin/stat.php on line 30

which is...

29 - while($rows=mysql_fetch_array($result)){ 
30 -      $myarray($rows['id']) = $rows['views'];

benracer

sorted thank you, a few minor changes...

<?php
while($rows=mysql_fetch_array($result)){ 
      $myarray[$rows['id']] = $rows['views']; 
} 
echo '<table>'; 

echo '<tr>'; 
foreach($myarray as $k=>$v) { 
?><td><img src="../images/bar.jpg"  width="30" height="<? echo $v; ?>"/></td><? 
} 
echo '</tr>'; 

echo '<tr>'; 
foreach($myarray as $k=>$v) { 
?><td><? echo $k; ?></td>
<?

} 
echo '</tr>'; 

echo '</table>';

TheDefender

Sorry about the paren/square bracket confusion. I'm in .NET mode at my office... Did that get you what you needed? If so, be sure to mark the thread resolved... Thanks.