You are here: Re: [PHP] Walking through a bunch of MySQL Records « PHP « IT news, forums, messages
Re: [PHP] Walking through a bunch of MySQL Records

Posted by Miles Thompson on 11/14/05 23:45

First of all - remember results display in a web browser, and if you want
to print these you will get results that are not like a normal printed page.

Second - here's an approach. Dump all records into an array, you'll have
the record count, then selectively fetch elements according to how you
want them displayed. Here's a rough approximation.

i = 1
col_lgth = 5
until i = 1+col_lgth+i
tr td
arr[i]
/td td
arr[ i + col_lgth ]
/td /tr
i ++
and keep on looping. You'll have to work out something for odd-numbered
result sets, which will not give you a balanced column.

Others may have more sophisticated displays, a CSS guru could probably do
something tricky.

I do not think you can access the $result value returned by any of the
queries with an index.

HTH - Miles



At 03:03 PM 11/14/2005, Phillip S. Baker wrote:
>Greetings all,
>
>I have a question.
>I want to display a group of records pulled form a MySQL db in the following
>fashion.
>
>1 6
>2 7
>3 8
>4 9
>5 10
>
>Now I can easily figure out how to display the records as
>
>1 2
>3 4
>5 6
>7 8
>9 10
>
>But since I am in an HTML table and the need to display the <TR> and </TR> I
>am not sure how to make th logic so that I can get the first listing. Can
>anyone help me out?? Need more information??
>
>Thanks
>
>Phillip
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация