(Solved)Mysql display everything from a row with certain val
Posted: Wed May 11, 2011 5:02 am
Hi i have table called pack, with columns (pack, level, colrow1, colrow2, colrow3, colrow4, colrow5, colrow6, colrow7, colrow8, colrow9, colrow10)
i want to display everything from a row like this.
for example where pack is equal 1
I want it to display it like this:
Level: 'level'
'colrow1'
'colrow2'
'colrow3'
'colrow4'
'colrow5'
'colrow6'
'colrow7'
'colrow8'
'colrow9'
'colrow10'
Level: 'level'
'colrow1'
'colrow2'
'colrow3'
'colrow4'
'colrow5'
'colrow6'
'colrow7'
'colrow8'
'colrow9'
'colrow10'
and so on
How would i do that?
I hope you understand
i want to display everything from a row like this.
for example where pack is equal 1
I want it to display it like this:
Level: 'level'
'colrow1'
'colrow2'
'colrow3'
'colrow4'
'colrow5'
'colrow6'
'colrow7'
'colrow8'
'colrow9'
'colrow10'
Level: 'level'
'colrow1'
'colrow2'
'colrow3'
'colrow4'
'colrow5'
'colrow6'
'colrow7'
'colrow8'
'colrow9'
'colrow10'
and so on
How would i do that?
I hope you understand