* Peter Sampson > Maybe it doesn't work because I'm using a SQL wizard in Ultradev, I'll try > your code in the HTML/ASP part of the webpage > > The table structure is > Month > Headline > Image > Caption > Content
Peter, you say you're not a programmer, and I'll try to explain a little about the more technical sides to this database thingy, while keeping it understandable to normal people... sorry in advance if I don't succeed. :) The fields of a table has a type, in addition to the field name. The field types are actually a lot more important than the names... :) I don't know the tool you are using, so I can't advise on how you can find this information, but from how you describe your problem I am guessing all your fields are of type VARCHAR or TEXT. These are field types intended for storing text, and a natural choice in many cases. There is however no magic involved, mysql does not know that the words you store in the column actually are names for months, and consequently not what would be the correct calendar order of the months... :) Luckily there are more field types, specialized for numbers and dates. You could use a numeric field type, and store your months as the numbers 1,2,3...12, and your application could translate the number to a month name. "ORDER BY Month" would give the correct calendar order. You got an advise on the list to create a MonthNames table. I never do that, because it is so simple to do it programatically. However, if you can not translate the numbers to month names in your application, it may be the only way, and anyways the technique used is basic relational database theory, so if you are going to work with databases, you probably need to learn it. ;) btw, did you test the suggestion in my previous post? -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
