Database Forum
Web Database Register Members List Calendar FAQ

 
Go Back   Database Forum > PHPMagic Discussions > General questions
User Name
Password

Reply
 
Thread Tools Search this Thread Display Modes
Default date oreder by desc;
03-29-2012, 05:43 PM #1  

adiv21
Junior Member

 
Status: Offline
Posts: 6
Join Date: Nov 2011

hello,
i am intresting to show the db table date order by desc(default),

I am trying to add a code for view the table date desc, I added the code in dirot_m_view.php in line 26:
$x->Query = "select dirot_m... FROM dirot_m ORDER BY date DESC";
Also in line 31: // Query used in table view It display the table order by date desc but when I used the filter search it makes a syntax error of using this command.
i got this code:
if($HTTP_POST_VARS['SortField']==""){
$HTTP_POST_VARS['SortField']="4 desc,5";
$HTTP_POST_VARS['SortDirection']="desc";
}
if($HTTP_GET_VARS['SortField']==""){
$HTTP_GET_VARS['SortField']="4 desc,5";
$HTTP_GET_VARS['SortDirection']="desc";
}
it didnt work,i swiped this code with the orginal code of handling date sorting
in dirot_m_view.php.
thanks for any help with this.
Reply With Quote

Default
03-31-2012, 06:01 AM #2  

Lana
Senior Member

 
Status: Offline
Posts: 110
Join Date: Oct 2007

Perhaps this thread will help.

I usually just click on the column name to do any sorting. Takes just one mouse click.
Reply With Quote

Default found the answer
04-21-2012, 12:21 PM #3  

adiv21
Junior Member

 
Status: Offline
Posts: 6
Join Date: Nov 2011

after i found the image link it was easy to found the link for date desc;
http://www.isradira.com/dirot_m_view...Direction=desc
11=the place of date field in table.
thank you.
Reply With Quote

Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -5. The time now is 06:56 AM.

Powered by: vBulletin Version 3.7.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Database Forums

Help support our forum assistants and product development ->

go to top go to top