hi, I have two tables say customer_tbl and record_tbl the customer table stores all details abt the customer like name , id , address, email etc and the record table stores the daily records of the customer like id, marks_scored, total marks, date etc .. in the reports.php page i display the reports based on date selected .. this takes data from both the tables and displays name, email, marks_scored and total marks .. now i need to sort the data by clicking the title of each column.. for ex. when clicking the 'name' title , the report should be displayed by sorting the data based on the name .. how do i handle this .. which is the best method to handle the above Thanks and Regards, Vipin Chandran -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php