I have 2 tables: items and listings. I want to select the item information along with how many listing reference that item. This is what I have now:

SELECT COUNT(listings.id)- items.name FROM listings- items WHERE listings.item = items.id GROUP BY items.id

Right now- it doesn t return an item if no listings reference it. I want to have it return the item name along with 0 for count.

Thanks in advance.

My web site is hosted by Yahoo Web Hosting and it comes with a MySQL database. I am trying to access that database thru a java applet and wondering if this is possible before I look at other options.

My database is accessed;
-When form data is submitted.
-When i approve profiles one at a time.
-When users are rating(accessed twice in same script action)
-When users select hyperlinks which display database content in a web page.

I am looking for an excel spreadsheet or mysql table containing all US zip codes and corresponding city names for some programming work I am doing. To my shock and horror- I cannot find a place to get this information for free.

Where can I get this list for free?

Hi there-
Is there a free hosting that has at least 100MB disk space- equipped with MySQL server- and with Fsocket functions enabled?
Thanks in advance.

i m making a music website that offers different music streams from some known artist. i use some php and mysql. so others can post some music links and pictures of them. but im not satisfied until now because i think something is missing. can somebody here give me some idea on how will i have many more visitors on my site and how can i make my site more attractive and useful? here it is http://iskolokoycafe.co.cc thanks