I am working on a job module where i have to fetch company name having more jobs. like
abc 20 jobs
def 30 jobs
ghi 10 jobs
jkl 40 jobs

what i want to do, job order acc to job number like below
jkl 40 jobs
def 30 jobs
abc 20 jobs
ghi 10 jobs
NEED your suggestions

as far as my knowledge is concern.

create 2 tables
company and jobs
for every (primary key)"companyid" match in jobs table (foreign key) "companyid".
from their you can count how many jobs per company.

that is one-many relationship of database.

Try this idea.

// sql connection here

$query = mysql_query("select * from tbl_name order by number_of_jobs desc");
   echo $result['company_name'];
   echo $result['number_of_jobs']."<br>";


Hi so you want sorting on your table?
And is it in mssql?

its not exactly like sorting.we have to sort acc to number of jobs per category contain.

I don't know that whether i get your question correctly,but try this

select companyName ,count(companyName ) from company,jobs
where company.companyId=jobs.companyId
group by companyName 
order by count(companyName ) desc

Hope it helps... :)

check the code given by lyrico...it will fulfill ur requirement.....