Formating mysql data horizontal?

itandme

Hi!

Is it possible to output mysql records like horizontal instead of vertical?

For example a news scipt often goes like:

NEWS

But in my case, I want to displat 3 images horizontal then change line:

OUTPUT OUTPUT OUTPUT
OUTPUT OUTPUT OUTPUT
OUTPUT OUTPUT OUTPUT

😃 😕

stolzyboy

check out this post i helped someone else out on, it seemed to work for them

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10225708

itandme

ok i understand the logic in it, but i am not totally sure about the % thingy. i dont see what its representing, i have looked in the manual but what the heck is "Remainder of $a divided by $b." means. (not good at maths)

and also, can you please maybe help me with my little thingy? mine is more simplier as its only display max 4 inputs, and they all fit in one line.

start
INPUT INPUT INPUT INPUT
end

i was simply thinking of doing something like:

$num = mysql_num_rows($thumbnails);
if ($num == 1) {
table code for 1 input/image
}
if ($num == 2) {
table code for 2 inputs/image
}

and so on up to 4. But i belive that is a bit.. not neccesary or how you would put it.

how would you do this?

thanks

stolzyboy

% is what they call the modulus operator, it returns the remainder of what you are diving, for example the modulo of 6/5 would be one, 8/5 would be three and so on, remember doing simple division and you had the answer, then an R and a remainder, well it gives you the remainder when doing that, neat huh, as far as what you are asking me, what you said before is quite different than what you want now, can you provide me with an example of what you are doing online?? If not look at what i have done closely it is really straight forward, for example the % 3 part, if you want two horizontal then new row, replace 3 with 2, etc... otherwise explain a little more so either i or someone else can help

itandme

ok thankyou.

this is somewhat what i am doing. (i am doing all the templates now so dont care about the text itself as its crap right now)

in the top of the page, you see two images that are going to be thumbnails with links to the full size screenshots. my little publishing system is designed so that 4 screenshots is max. when i publishing it i can only upload 4.

so what i want is simply that the collums goes on for every screeny up to 4..

I have a strange feeling this is a pretty simple thingy.. i prob not thinking clearly right now 🙂

how would you do?
(dont care about the error msg, the include files are out in another dir)
http://lorenscorn.net/dicemania/test/

stolzyboy

would the limit() statment help you at all, check it out at mysql.com, sorry but i am still kinda confused on what you are doing

itandme

well, first of all, i need to count the rows for the hits. lets say SELECT thumg_id FROM screenshots where ID = $id.

´now mysql_num_rows is MAX 4. there can only be max 4 records for one $id.

now i just want to display them in the top table, one in each cell.

and i just got a little flash of how i should do this.. yees. i think i got it now..

thankyou annyways

stolzyboy

itandme

yup.. i didnt think clearly last night.. sorry!

😃