display the result on 2 columns

[ovisopa]

Hello ppl.

Can some body tell how can I display my data from a db like this:

<table border="0" width="415">
<tr><td>row1</td><td>row2</td></tr>
<tr><td>row3</td><td>row4</td></tr>
<tr><td>row5</td><td>row6</td></tr>
.......
</table>

Every table from my db has 6 filds: id, name, adress, tel, respect, pic, and is a short text in every field , the filds from a row will be displaied with a <br> between .
If i display all my rows in a single column the rest of page will be empty.. and that's not what I want .

Can somebody give me a sugestion? anithing..
10x see ya

[Kerry_Kobashi]

This is an interesting question because I may need to do something like this in my own project.

I believe what you are asking for is a way to render data in a snaking column fashion. Right?

That is, you fill column one to the end (need a physical limitation in table size), then snake up to the second column and fill.

One thing to observe is that by placing a physical limitation in column #1, you also impose a limitation in column #2. This means, also that you are limited in what can be displayed in a table and will also have to work with the problem of what happens when it spills over column #2. This would then require the concept of a Pager object, similar to how Google handles their navigation.

Understand what I am saying here?

Kerry Kobashi
Kobashi Computing

[ovisopa]

Hy Kerry Kobashi ,

I understand what you said but I still dont know how can I do my script, I'm a beginner in php 🙂
The problem with the limitation of col #1 I think is not such a big problem, If I make a query like this :

$query = "select * from mytable";
$result = mysql_query($query) or
	die (mysql_error());
$totalrows = mysql_num_rows($result);
//here will be something to divide my resul by 2
//I dont know how to make this now, but I will :)

I can have a good value for the numbers of cols.

Maibe you can help me 'cause I told you I'm a beginner to this
Anyway 10x for sugestions

...... see ya