From: Hameed U. K. <ham...@gm...> - 2006-08-11 15:37:56
|
Hi, I'm having problems in executing and displaying more than 2 sql queries. I want to generate two report tables. I have a table in my mysql named clean. Which have following structure. ID : STATUS : DATE : TIME: IP : from : to I want to split tables based on the status field. The queries I'm executing are: 1. SELECT * FROM clean WHERE status = 'sent' 2. SELECT * FROM clean WHERE status = 'recv' The output which I'm trying to get is: ______________________________ Sent --------------------------------------------------- rows here... ____________________________ Recv ------------------------------------------------ rows here... I've attached all the files and mysql dump. Kindly If any can guide me how can I solve this scenario, I'll be very thankfull to you. Thanks. -- Hameed U. Khan Registered Linux User #: 354374 "Beware of programmers who carry screwdrivers." |