php and html

[hemi]

<div id='sss' class='col'>
<h4>for sale</h4>
<div class='cats'> <div class='cats'><ul id='ccc1'>
";
$res=mysql_query("select * from post_subtypes where postid=16");

while($var=mysql_fetch_array($res))

{

echo"<li><a href=sale1.php?id=$var[cid]><font size=2> $var[name]</font></a></li>";
}
echo"</ul>
</div>
</div>
------------------------------------------------------------------------
when i do this i will get my required values in a single row. what I want is to get them in two rows (half in one row and the other half in another row)

any suggestions plz

[JShor]

I did this the other day. Thing is I used it for an array, not a mysql db, but I changed it for mysql, hopefully this'll work. Here you go:



<div id='sss' class='col'>
<h4>for sale</h4>
<div class='cats'> <div class='cats'><ul id='ccc1'>
<?php

echo '<table border="0" cellspacing="10" cellpadding="0" align="center">';

function print_data($rows, $cols, $offset) {
if($rows > 0) {

$res = mysql_query("select * from post_subtypes where postid=16 LIMIT $offset,$rows");
$offset = $offset + $cols;

echo "
<tr>";
while($var = mysql_fetch_array( $res )) {
echo '
<td>
<li><a href="sale1.php?id='.$var[cid].'"><font size="2">'.$var[name].'</font></a></li>
</td>';
}
echo "
</tr>";
$rows = $rows - 1;
print_data($rows, $cols, $offset);
}
}
echo"</ul>";

$rows = 5000; //rows to display
$cols = 2; //columns to display
$offset = 0; // offset, good for paging

print_data($rows, $cols, $offset);
echo "</table>";

?>
</div>
</div>


HTH:)

[hemi]

thnks it is working