I am trying to develop a e-book management system in php MySQL where a chaper or a sub-chapter may have one or more subchapter, like 1 1.1 1.1.1 1.2 1.3 1.3.1 1.3.2 1.3.3 1.4 2 2.1 2.1.1 How can I construct a query so that first 1 then 1.1 then 1.1.1 then 1.2 .... will be diaplayed Regards, Sourav ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/