MikeJComputer

Just something for my website... Don't care if I never get it to work... been using it as-is for 4 years

I have a database of entries that I want to order by date. I've been ordering them by date simply by putting them into the database in order and sort on their uin. I have a date field, but it's stored as a varchar in mm/dd/yy format. I would like to sort records on that instead so if I forget to put an entry in, I don't have to backtrack to have it get placed in the right place.

My current query:

$sqldata = "SELECT * FROM ".$db_prefix."entry ORDER BY `uin` DESC";

I've done 5 minutes of messing around with date and type conversion crap, but to no avail. It's not worth me putting in any more time than that, but if any of y'all are SQL gurus, I'm sure you'll have an answer in seconds.

The output: http://www.iammike.org/index.php?loc=log

__________________
I Am Mike | Madison Motorsports

RIP

Haven't done a whole lot of SQL, but enough to know that this is bad times. Why not convert your field into the date type? It's the Right Thing to do...

__________________
Jak: 12 years gone by as if it was yesterday. Not long ago i came to the US barely able to put together a short sentence. Now i can put together one full sentence.

Kleptosis

Have you tried using order by in conjunction with convert?

__________________
Before you talk shit about someone, you should walk a mile in his shoes. That way, when you talk shit about him, you're a mile away and you have his shoes.

rdg

google "mysql str_to_date"


if you can't set it to default "10" to "2010" for the year.. then adjust the string date to 2010 and then run str_to_date.. you could even do that on the fly in a subquery.

__________________

MikeJComputer

yes.

��»»»�»»�»»»»»»»»»»«««««««««««««
�»» AutoMerged DoublePost ««
»»»»»»»»»»»»»»»«««««««««««««

would require the rewrite of some code, which would take more than 5 minutes, but not likely more than 20. still, too long.

��»»»�»»�»»»»»»»»»»«««««««««««««
�»» AutoMerged DoublePost ««
»»»»»»»»»»»»»»»«««««««««««««

will look into this.

__________________
I Am Mike | Madison Motorsports

Kleptosis

Yes, obviously that's the right thing to do. He's trying to get us to find a shortcut for him, though.

__________________
Before you talk shit about someone, you should walk a mile in his shoes. That way, when you talk shit about him, you're a mile away and you have his shoes.

rdg

haha. indeed he's looking for us to paste in a sql query for him to run.. and I really want to just to commit to memory how to do it but i refuse to assist mike

(because I'm in another country)

__________________

MikeJComputer

Is this what you looked like when you told that driver how it was?

__________________
I Am Mike | Madison Motorsports

RIP

And, as I would predict, in looking for the shortcut, he is probably spending more time than it would take to fix the problem the right way. Obviously it's the right thing to do - often when I code and am looking for shortcuts, I just need to be told by someone to do the obvious thing. Also, if he doesn't actually fix the real problem, then a year from now when he wants to do something else, he'll have to come up with another workaround. I was just trying to help by suggesting that he bite the bullet, get 20 fewer minutes of sleep, and fix the problem the most effective way. If you don't care for this explanation, you may kindly lick my buttocks

__________________
Jak: 12 years gone by as if it was yesterday. Not long ago i came to the US barely able to put together a short sentence. Now i can put together one full sentence.

Araemo

Pft. What country? Canadia?

__________________
I shove around the blind people.

MikeJComputer

I thought I already made it clear that this is not worth 20 minutes of my time. If you don't know a "shortcut," kindly STFU.

__________________
I Am Mike | Madison Motorsports

Kleptosis

You all are forgetting how important Mike is and how much each minute of his time is actually worth. If you only knew...

__________________
Before you talk shit about someone, you should walk a mile in his shoes. That way, when you talk shit about him, you're a mile away and you have his shoes.

MikeJComputer

GOD DAMN! Good one!

__________________
I Am Mike | Madison Motorsports

RIP

And how much time would you say you've spent so far on these TPS reports?

__________________
Jak: 12 years gone by as if it was yesterday. Not long ago i came to the US barely able to put together a short sentence. Now i can put together one full sentence.

Mortal_Wombat

fucking lol.

__________________
(╬ಠ益ಠ)