Selecting From MySQL Database Question...
Posted: Sun Dec 07, 2003 7:09 pm
I have a table which records items with a number. E.g:
key1 key2 key3 key4 key5 key6 key7 key8
5 1 0 0 0 0 3 0
Now what I want to do is show those results on a page BUT for each row(key#), I want to show it the amount of times the number that is recorded in it. For key1, it would show results of it 5 times. for key2 it would show it 1 time. E.g:
Key1
Key1
Key1
Key1
Key1
Key2
Key6
Key6
Key6
How can I do this? I could do this without doing it this way except I'm going to have up to 75 results to select...
Let me know if you don't explain because I'll try to explain better.
Thanks
Ben
key1 key2 key3 key4 key5 key6 key7 key8
5 1 0 0 0 0 3 0
Now what I want to do is show those results on a page BUT for each row(key#), I want to show it the amount of times the number that is recorded in it. For key1, it would show results of it 5 times. for key2 it would show it 1 time. E.g:
Key1
Key1
Key1
Key1
Key1
Key2
Key6
Key6
Key6
How can I do this? I could do this without doing it this way except I'm going to have up to 75 results to select...
Let me know if you don't explain because I'll try to explain better.
Thanks
Ben