Looking for help on output rows in a table

Expand Post »

Good Evening,

I have a table that has a field with 15 entrys in it. I would like to output it from a query in a table that has 3 rows of 5. However, whenever I put a <tr> inside the loop, I get 15 rows. Any idea how I can get it to do three rows of 5.

X X X X X
X X X X X
X X X X X

PHP Syntax (Toggle Plain Text)
<?php
$result = mysql_query("SELECT bull FROM draftpick_grid order by bull ASC")
or die(mysql_error());  
 
echo "<tr> 
<tr bgcolor='000000'>
<td colspan='100%' align='center' width='150'><img src='/images/bar_bull.jpg' width='150' height='19' border='0'></td>
<tr>
 
";
 
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
 
 
 
	echo "<tr><td width='30' align='center' bgcolor='FFFFFF'><font face='arial' size='1' color='000000'>";
	echo "<img src='/images/".$row['bull'].".jpg' width='28' height='28' alt='Bulldogs'>";	
 
 
}
 
 
echo "</td></table>";
?>
<?php
$result = mysql_query("SELECT bull FROM draftpick_grid order by bull ASC")
or die(mysql_error());  

echo "<tr> 
<tr bgcolor='000000'>
<td colspan='100%' align='center' width='150'><img src='/images/bar_bull.jpg' width='150' height='19' border='0'></td>
<tr>

";

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	


	echo "<tr><td width='30' align='center' bgcolor='FFFFFF'><font face='arial' size='1' color='000000'>";
	echo "<img src='/images/".$row['bull'].".jpg' width='28' height='28' alt='Bulldogs'>";	
	
	
}
	
	
echo "</td></table>";
?>

The above code gives me 15 rows....if I take out the <tr> I get one row of 15. I want 3 rows of 5. Anyone?

Similar Threads

Delete all rows from table in javascript in JavaScript / DHTML / AJAX
Return number of rows in table in MySQL
How to swap two rows of a table in a database using php in PHP
Delete top 5 rows from a table in MS SQL
SUM two fileds from different rows from the same table in MS SQL

ceeandcee

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

72 posts
since Aug 2010

Permalink

Sep 1st, 2010

Re: Looking for help on output rows in a table

Disregard. I got it to work!

ceeandcee

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

72 posts
since Aug 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Quick question about form input?

Next Thread in PHP Forum Timeline: How to stop sending data on refresh

DaniWeb Message

Cancel Changes

User Name
Password