Arranging rows for dynamically creating table

**bharanidharanit** · Feb 11th, 2010, 09:21 PM

Hi,
I am using this coding to create a dynamic table for filling only 2x3 tables.

Code:

<html>
<head>
<style type="text/css">
.friends_avatar
{
width: 50px;
height: 50px;
}	
</style>
</head>
<body>
<?PHP
require_once('functions/dbconnect.php');
$columns=3;
$count=1;
$query="SELECT u.username
FROM users u
WHERE u.id
IN(
SELECT friendid
FROM friend 
WHERE userid='113'
AND arefriends='0')";					
$result=mysql_query($query) or
die(mysql_error($dbconn));	
if(mysql_num_rows($result) <1 )
{
echo "No friends for users";
return false;
}
?>
<table border="0" cellpadding="0" cellspacing="0">
<?PHP
while($userdata=mysql_fetch_array($result,MYSQL_ASSOC))
{
$username=$userdata['username'];
if($count%$columns == 1)
	{
		?>
			<tr>
				<td class="friends_avatar_list">
				<table border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td align="center">
							<a href="<?PHP echo($navurl); ?>"><?PHP echo($username); ?></a>
						</td>
					</tr>
				</table>
				</td>
				
		<?PHP
	}
	else if($count%$columns == 0)
	{
		?>
			
				<td class="friends_avatar_list">
				<table border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td align="center">
							<a href="<?PHP echo($navurl); ?>"><?PHP echo($username); ?></a>
						</td>
					</tr>
				</table>
				</td>
			</tr>							
		<?PHP
	}
	else
	{
		?>
		
			<td class="friends_avatar_list">
			<table border="0" cellpadding="0" cellspacing="0">
				<tr>
					<td align="center">
						<a href="<?PHP echo($navurl); ?>"><?PHP echo($username); ?></a>
					</td>
				</tr>
			</table>
			</td>
		
	<?PHP
	}
	$count++;
}	
	


$count--;
	if($count%$columns!=0)
	{
		?>
			</td>
	  		</tr>
			</table>
			</body>
			</html>
		<?PHP	
	}



?>

But now i want to fill each 2x3 table in a seperate div. How to do this?
Any Ideas???

**kows** · Feb 12th, 2010, 01:44 AM

umm. first of all, you should just make your code always echo out the <td>, all you're doing is repeating the same code 3 times and you're just adding a <tr> or </tr>. use your IF statements to figure out whether or not you need to echo the <tr> before the <td> or the </tr> after the <td>.

anddd, if you want to start creating multiple <table>s, each within their own <div>s, then you need to have IF statements that checks the value of $count to see if you're at the beginning of the table so that you can create the div/table, and then another IF statement to check if you're at the end of your table, so that you can end the table/div and reset the counter. then, the next iteration will start a new table.

hope that makes sense.

Thread: Arranging rows for dynamically creating table

Thread Tools

Display

Arranging rows for dynamically creating table

Re: Arranging rows for dynamically creating table

Posting Permissions