mysql count query
i have 2 table with some 100 entries, of which some say 70 entries have images in them, these images r stored in different table
is it possible to get result like
image 70 30
in a single query???
i am running query like
SELECT imagetype.image_type, count( docs.ids ) AS 'Image_present' FROM docs, imagetype WHERE docs.ids = imagetype.id AND imagetype.image_type = "Image1" GROUP BY imagetype.image_type
and i am getting result as
now i want the count without images it's 30 here, what to add in the query??
thanx in advance
Last edited by gayatri; 03-21-2006 at 04:46 AM.
You need to make it separate.
ya i have done it with 2 queries now
but i just wish there could have been a single query, my code would have looked a little good than now
thanx for reply
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)