[RESOLVED] Sort the data - how?

[neizo]

Hello,

one of my partners send me an example (design) how to he wonts to sort the data from mysql, look at picture (Untitled-1.jpg).

I try it, and I can't find the way how to do this.
I use this code

<tr>
            <td height="60" colspan="3" align="left" valign="top" bgcolor="#98B0DE"><div class="maincontent">
                <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus  imperdiet condimentum ipsum. Nam dolor. Lorem ipsum <strong>dolor</strong> sit amet,  consectetuer adipiscing elit. Mauris sed nunc. Pellentesque ut nisl  eget elit convallis congue. <strong>Curabitur risus</strong> dolor, sollicitudin nec,  sollicitudin pellentesque, vehicula sed, tortor. Aenean vulputate  vehicula nulla. Mauris ipsum nisi, suscipit at, cursus non, lobortis  ut, turpis. Sed <strong>tristique</strong> facilisis orci. Morbi tincidunt gravida  mauris.<font color="#FFFFFF">[&#931;&#964;&#945;&#952;&#949;&#961;&#972; &#954;&#949;&#943;&#956;&#949;&#957;&#959; - &#972;&#967;&#953; &#948;&#965;&#957;&#945;&#956;&#953;&#954;&#959;]</font></p>
                </div></td>
            </tr>


		<? include("inc/connect.php");
		$result_kod = mysql_query("SELECT * FROM category ORDER BY TAX");
		while($rows = mysql_fetch_row($result_kod))
		{		
		?>
		<tr>
		<td width="33%" height="110" align="center" valign="middle" bgcolor="#98B0DE" class="maintext">
		<p><a href="products-more.php?page=<? echo($rows[0]); ?>"><img src="images-katigories/<? echo($rows[2]); ?>" width="120" height="70" border="0" class="homeimages-border"></a><br><? echo($rows[1]); ?></p>
		</td>
		</tr>
		<?
		 }
		?>

And the result is like the picture (Untitled-2.jpg).
So, how can I sort the data like the first picture? I mean 3 products per line and the next 3 products under the first 3 etc.

[neizo]

Any ideas please?
or keyword for search.

[like_php]

change your code fom:

$result_kod = mysql_query("SELECT * FROM category ORDER BY TAX");

to:

$result_kod = mysql_query("SELECT * FROM category ORDER BY BINARY TAX");

[neizo]

Is not working..😕

[neizo]

I found some solution, I put outside from php the tags <tr><td> and the data is side by side now.🙂

Thanks.