Help please.

[yuws]

I need help by getting this content to go in rows of 3 horizontal.

 

right now it lines up strait down.

 

Here's the code:

 

<?php include 'functions.php'; ?>
<?php
connect();
$id = mysql_escape_string(intval($_GET['id']));
$query = "SELECT * FROM `users` WHERE `id` = '$id'";
$result = mysql_query($query);
$numrows = @mysql_num_rows($result);
if ($numrows != 0)
{
	$row = mysql_fetch_array($result);
	$name = stripslashes($row['username']);
	$query = "SELECT * FROM favorites WHERE uid='$id'";
	$result = mysql_query($query);
	$numrows = @mysql_num_rows($result);
?>
<table border="0" cellpadding="0" cellspacing="0" width="742px" class="side">
<tr>
	<td class="btitle" valign="top" colspan="2"><?php echo $name; ?>'s Favorites</td>
</tr>
<tr>
	<td align="left" valign="top">
		<table border="0" cellspacing="0" cellpadding="0" width="100%">
<?php
	if ($numrows != 0)
	{
			$dl = "celll";
			$i = 0;
			while ($row = mysql_fetch_array($result))
			{
					$game_id = stripslashes($row['gameid']);
					$q = "SELECT `name`, `description`, `image`, `display` FROM `ava_games` WHERE `id` = '$game_id'";
					$r = mysql_query($q);
					$rw = mysql_fetch_assoc($r);
					$gt = stripslashes($rw['name']);
					$ds = stripslashes($rw['description']);
					$im = stripslashes($rw['image']);
					$display = stripslashes($rw['display']);
					$i++;
					if ($i % 2 == 0)
					{
							$dl = "celll";
					}
					else
					{
							$dl = "celld";
					}
					if ($display)
					{
?>
			<tr>
				<td width="35" height="35" bgcolor="ffffff" class="text"><? echo '<img src="<?php echo $im;?>" alt="" width="90" height="90" />';?>
<font color="#333333"><b>
					<a href="game.php?id=<?php echo $game_id; ?>" class="dlink"><?php echo $gt; ?></a>
					</b></font></td>

<?php
					}
			}
	}
	else
	{
?>
			<tr>
				<td align="center" class="content">
					<br><?php echo itou($id) . " has no favorites yet."; ?>
				</td>
			</tr>
<?php
	}
?>
		</table>
	</td>
</tr>
</table>
<?php
}
else
{
	message("User not found.  Please check the link and try again.");
}
mysql_close();
?>
<?php
?>

 

if anyone could help me fix this, that would be awsome!

[yuws]

Anyone know how?

[yuws]

bump

[revraz]

Check the FAQ forums, there is a guide there.

[yuws]

guide for what?

[revraz]

For what you asked for

 

I need help by getting this content to go in rows of 3 horizontal.

 

 

guide for what?

[yuws]

FAQ/Code Snippet Repository?

 

ive checked there but i didn't see anything that would help, if you did see anything mind posting link?

[GrayFox12]

youve set vertical alignment (valign) for ur table.  Also you have valign your <td> tag which will align your variables inside that tag vertically

[yuws]

so (halign) would work? and take out <td>?

[GrayFox12]

leave your <td> tag and just remove your valign from it.  Should default to horizontal.

[GrayFox12]

that might not be the cause, ill have a look soon for you

[yuws]

yea it didn't work.

[yuws]

taking out valign didn't make anydifference.

[GrayFox12]

I just copyed your html table, all writing comes out horizontal.  So your table is fine

[GrayFox12]

How are you wanting it?

 

you want 3 colomns and 1 row?

[yuws]

yea i want it to show a max of 9 games, but 3 in each row.

[yuws]

also grayfox i sent you a pm.

[yuws]

bump

[yuws]

anyone else know how to make it work?

[yuws]

bump

[yuws]

bump

[yuws]

bumpppp 

[yuws]

anyone out there gonna help?

[Pioden]

Hi,

 

So you want a table with three columns? OK if I understood properly it works like this. You need to code a little counter for your output. When $count > 3 it resets and starts a new row.

 

<table >

  <tr>

    <td>1</td>

    <td>2</td>

    <td>3</td>

  </tr>

</table>

 

Start you loop with <tr>

Put the results in <td>'s

When the result counter gets to 4 it echo's </tr> and starts the process again.

 

That's the way it works anyway. I coded this once but I don't remember in which file the code lives! The only 'hard' bit if adding the extra empty <td>'s if you have an inconvenient number of results e.g. if you have 10 results you'll need to add two <td> sets to finish the table in a tidy way.

 

HTH

 

Huw

[yuws]

Can anyone explain how to make it go horizontal?