Bug #5783

Pager do not take care of "order" clause in sql request

Details

Request #5783	Pager do not take care of "order" clause in sql request
Submitted	2005-10-25 20:20 UTC
From	pluton dot home at free dot fr
Assigned	quipo
Status	No Feedback
Package	DB_Pager
PHP Version	4.3.8
OS	linux mandrake 10.1
Roadmaps	(Not assigned)

Comments

[2005-10-25 20:20 UTC] pluton dot home at free dot fr

Description:
------------
given the following request"
SELECT * FROM main_db,main_info where main_db.id = main_info.id ORDER BY 'doc_name'
given a link of this type :
// page suivante
printf('<a href="%s?order_by=%s&offset=%d">
next</a>','tab_it.php',$orderby,$data['next']);
the order clause inside the sql is not respected by Pager that is always returning pure numeric order.