Click to See Complete Forum and Search --> : Does MYsql enter in rows or columns


Dragonkai
10-21-2007, 05:07 AM
I have a loop which enters text into two columns in one table. It will loop until the end of file. When it loops, it will only ever enter one text into one of the columns. So the next time it loops it will alternate between which column it enters into.

Sometimes the text that's meant to be entered doesn't exist, so it skips it. What I want to know is when it alternates back to the column that it ignored, will it enter it into the same row as the column it was entered before or will it just stack up on the one that it skipped. Because it if stacks up, then my table will get muddled up.

But if it enters through rows, so when it alternates the two data they both will always be on the same row then it would be all good. If it doesn't do the latter than how will I make it for the latter?

Thanks in advance.


Example:

Column1 Column2
BLAHBLAH BLAHBLAHBLAH (This one was all good)
BLAHBLAH (Apparently column 2 text did not exist)

(Here's the problem... does it go)

A (the bad outcome):

BLAHBLAH BLAHBLAHBLAH (It Stacks up... not good as it muddles with rows)
BLAHBLAH

Or B (the good outcome):
BLAHBLAH
BLAHBLAH BLAHBLAHBLAH (It enters as a row, rather than stacking up)