sandy1028 Posted September 12, 2007 Share Posted September 12, 2007 Hi, Please help me how to write the query. To fetch the different category of jobs(running,queued and completed) for the particular centre of the city. For each city there are different centres. The data should be displayed in this format CentreNames--------------------------- CityNames Running Queued Completed . . . Link to comment https://forums.phpfreaks.com/topic/69017-problem-in-query/ Share on other sites More sharing options...
pocobueno1388 Posted September 12, 2007 Share Posted September 12, 2007 Can you give us more information on your database setup? List the tables and what fields they have. Link to comment https://forums.phpfreaks.com/topic/69017-problem-in-query/#findComment-346946 Share on other sites More sharing options...
sandy1028 Posted September 13, 2007 Author Share Posted September 13, 2007 hi, Table contains city, centres,state. State is the type of jobs. It contains the fields R,W,P depending on state running,waiting or completed. How to write the query for paticular city and centres depending on the state the value should be filled in respective columns of R W P Please tell me how to proceed Link to comment https://forums.phpfreaks.com/topic/69017-problem-in-query/#findComment-347553 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.