Search found 7 matches

by cdrees
Thu Dec 22, 2005 10:47 pm
Forum: Databases
Topic: [resolved] Order by Date - Sorting Question
Replies: 2
Views: 546

worked like a charm

Thanks dude.... worked great
by cdrees
Thu Dec 22, 2005 2:41 pm
Forum: Databases
Topic: [resolved] Order by Date - Sorting Question
Replies: 2
Views: 546

[resolved] Order by Date - Sorting Question

I have a question about ordering by date. If I order my query so that I'm displaying my dates in December 21, 2005 format, how can I sort by date order, and not alphabetically by the name of the month? If other words, when I do this Select * FROM table ORDER BY course_date I get this: 2005-12-20 200...
by cdrees
Wed Dec 21, 2005 9:55 pm
Forum: Databases
Topic: Grouping Results - PHP or MySQL? Need Help!!
Replies: 6
Views: 1146

Solution Worked

You're solution worked great... thanks so much. I tweaked it slightly, as noted in the code section below: My next question however, is it possible (looping through the array) to display this information now into two main colums? I'd like to have it like so (I know my spacing is going to compress.. ...
by cdrees
Wed Dec 21, 2005 10:55 am
Forum: Databases
Topic: Grouping Results - PHP or MySQL? Need Help!!
Replies: 6
Views: 1146

Thanks

Great.... I will work with this for awhile and see if I can get it working...

Thanks so much! :)



Christopher D. Rees
A+, Network+, Server+, MCSE, MCT
COPT Certified Law Enforcement Instructor
http://www.teamrees.com
by cdrees
Wed Dec 21, 2005 10:47 am
Forum: Databases
Topic: Grouping Results - PHP or MySQL? Need Help!!
Replies: 6
Views: 1146

Making Sense

[/quote]Then, when you're looping through the results, keep track of the last course_title. If the course_title in the current row isn't the same as the course_title in the last row, then you're at a new course - output the name of the course, then keep looping through the rows. I understand what yo...
by cdrees
Wed Dec 21, 2005 9:38 am
Forum: Databases
Topic: Grouping Results - PHP or MySQL? Need Help!!
Replies: 6
Views: 1146

Grouping Results - PHP or MySQL? Need Help!!

Hello Everyone, I have a DB that I'm developing, that I've currently got functional, but I want to clean up the output. Currently, I have a site that displays currently available courses, listed by date. It shows the following: Course Date Course Title Notes =========================================...
by cdrees
Wed Dec 21, 2005 9:37 am
Forum: PHP - Code
Topic: Grouping Results - Need Help!!
Replies: 1
Views: 207

Grouping Results - Need Help!!

Hello Everyone, I have a DB that I'm developing, that I've currently got functional, but I want to clean up the output. Currently, I have a site that displays currently available courses, listed by date. It shows the following: Course Date Course Title Notes =========================================...