Getting sortet result from a MySQL table. [Resolved]

[NoteMe]

Is it some neith function that I can use to get my search result sorted by date from a MySQL table? If not is the only way to store all the rows in an array, and then make a sort function?

[NoteMe]

Or maybe there is a InesertSort function in some way?

[ober0330]

Other than using "ORDER BY yourdatefield" in your SQL statement?

[NoteMe]

DOn't play smart with me.......how the hell can I have gone through a Database class (theory) without ever heard abou that SQL statment..


Thanks, you are some kind of life saver here....I really thought I had to write my own Quicksort function in PHP here..

ØØ

[ober0330]

Originally posted by NoteMe
DOn't play smart with me.......how the hell can I have gone through a Database class (theory) without ever heard abou that SQL statment..

Bad professor?

[NoteMe]

Yeah...so bad that he made a bad student...



ANd I guess I need to use DESC or something to get it in the opposit order?

[ober0330]

You got it.

[NoteMe]

This thread is more then resolved......thanks.

[The Hobo]

I guess your professor forgot to give you the invite to the super secret database club too, didn't he?

[NoteMe]

Yeah he did...but I hate databases that much, that I am glad he did...is it one thing I wish I didn't have to learn, it would have been about databases....

We have a (X)HTML, CSS, PHP, MySQL class now..and he thought that the other teacher had thought us all about SQL queryes in the Database theory class, but I guess not since I havn't hear abou this.

He added something about MAX, SUM and something at the end of the year too, but never said how to use it. But at least I know it's there...

[kows]

databases are easy.. why do you hate them so much?

[NoteMe]

I think it is boring....just a buch of data....and it is slow and needs a lot of maintains. Game/Graphics progragramming on the other side, is much more fun. Wish I had more about that at school.

[The Hobo]

Databases are slow? It needs a lot of maintenance? Huh? Who gave you your information?

They're boring? Just a bunch of data? Well, everything else is just a bunch of code. That's not boring?

[NoteMe]

If you want to search for a record in a 1.000.000 records datbaseyou can't expect a frame rate of 50FPS like in a game no mather what way you are searching it....


And you need to delete old records, update old records. Reindex, and stuff like no one cares about but the one that is doing it....

At least in graphics programming you have something to lay your eyes on. Something that is both fun and can be beautiful. Only your imagination can stop you....

[The Hobo]

The computing world would be much different without databases. My best advice is to deal.

[NoteMe]

I am so fed up about teaching first greaders about datastructures and stuff.

But learnng new datastructures like OCT Tree, Quad Tree AABB trees and stuff like that can be fun. As long as you use them for games...


I know that you can't live with out databases, and there is a **** load of jobs out there where you need to know a lot about them. But I don't want that kind of job anyway. So let the people who like it get those jobs, and please let me join the 3D apartment at ATI in 4-5years...