Results 1 to 2 of 2
  1. #1

    Member Since
    Jul 25, 2004
    Gaithersburg, MD
    Mac Pro 2.6ghz Quad Xeon, 23" Cinema
    long shot: php mysql column represent query?
    Here's an example:

    we have two tables, one is called job_categories which has two columns:
    job_category_id (integer, primary key, auto increment)
    job_category_title (title of the job category)

    second table is titled jobs, which is a list of jobs. One of the columns is job_category_id to correspond to the category it belongs in. Say we want to get a query that will list each job category title individually, and then how many jobs exist in the jobs table with that category_id. i.e

    Architecture (3)
    Human Resources (8)
    Information Technology (0)
    Miscellaneous (19)

    Is there any way to do that query without having to do a count query individually on each row returned in some sort of a loop? I don't have any of my SQL books here (I'm at home with the family for Christmas, brought the powerbook with me).

    I know it's a long shot asking here, but if anyone can offer a suggestion or point me to a better forum please let me know!

  2. #2

    xstep's Avatar
    Member Since
    Jun 25, 2005
    On the road
    2011 MBP, i7, 16GB RAM, MBP 2.16Ghz Core Duo, 2GB ram, Dual 867Mhz MDD, 1.75GB ram, ATI 9800 Pro vid
    You've probably resolved this by now. I'm not even sure exactly what you want, but...

    select job_categories.job_category_title, jobs.job, count(*) mycount
    from job_categories, jobs
    where job_categories.job_category_id = jobs.job_category_id
    group by job_categories.job_category_title, jobs.job;


    If you could perform a loop through job_categories and use the id to find the jobs and count the result. I think maybe that is what you wanted to do, but I don't know how to do that in PHP.

    Note: The syntax I used above will work in Oracle which I'm very familiar with, but you may need to use AS before mycount.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PHP and MySQL
    By conor in forum OS X - Operating System
    Replies: 5
    Last Post: 06-11-2009, 08:44 PM
  2. A little help with PHP/MySQL
    By blinkdude182 in forum Web Design and Hosting
    Replies: 4
    Last Post: 02-08-2009, 02:52 AM
  3. PHP mysql
    By richardmojo in forum Web Design and Hosting
    Replies: 2
    Last Post: 05-09-2005, 11:05 PM
  4. PHP+MySQL Help.
    By design2 in forum Web Design and Hosting
    Replies: 3
    Last Post: 08-07-2004, 07:22 PM
  5. Apache + PHP + MySQL
    By Emrys in forum OS X - Development and Darwin
    Replies: 2
    Last Post: 11-14-2003, 02:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts