Guys, just wanted to thank you again for helping me with the sql statement that I needed. I was able to sorted using php and I was able to display the correct result.
Thanks again!!1 Nestor :-) On Nov 6, 2007 7:37 AM, Néstor <[EMAIL PROTECTED]> wrote: > You guys are correct, that is exactly what happened. > > I must thing of this in the future. > > At this moment I have a lot of other projects to take care, that it is > eaiser for me to read the information into an associative array with > the columns and the values and sort the array and then print the > top 5 values within each array. > > Thanks, > > Nestor :-) > > > > On 11/6/07, Enrique Sanchez Vela <[EMAIL PROTECTED]> wrote: > > > > > > --- [EMAIL PROTECTED] wrote: > > > > > Néstor wrote: > > > > > > > > I think you'd best begin by normalising your > > > database. Something along > > > these lines: > > > > > > > very true indeed, that would save you major headaches > > when right after finishing the demo, someone would > > say, "can we add a 18 gallon pledge? what about a 25?" > > > > > > as of the sort of columns per row, I believe it is not > > possible nor in the goals of MySQL to make it > > possible/easy. > > > > best regards, > > enrique. > > > > -------------------------------------- > > "What you have been obliged to discover > > by yourself leaves a path in your mind > > which you can use again when the need > > arises." --G. C. Lichtenberg > > > > http://themathcircle.org/ > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > >