![]() |
Sorting with Custom tables.
Hi folks,
I have the following SQL query I wrote. How do i get it to sort based on `u`.joindate? I looked in the table columns and it doesn't seem to be a conventional date. i just wanna through in an order by joindate. THanks in advance! ------------------------ SELECT ntd.*, u.* FROM `norcal_top_dawg` ntd, `user` u WHERE ntd.userid=u.userid ORDER BY ntd.et, ntd.mph, ntd.sixty_foot ASC; ------------------------ |
WishEr 'ORDER BY joindate' should work ;) because the numbers are only changed to be more 'date - like' looking when calling the vbdate() function ;) regards...
g-force2k2 |
All times are GMT. The time now is 01:42 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|