not all info is being retrieved from mysql using php

[Gina]

I have an odd problem. I have a database that is set up with zip code information that will find the nearest retailer for a specific zip code within so many miles.

My client uses phpmyedit to update the database. After updates are made some of the new retailers are not displayed on the website. I have checked the mysql tables that I use and they are all updated appropriately.

If I add the entry in the database twice and then go to the website and check the zipcode, the respective retailer displays twice. I tried to take one of the entries out of the database and the zipcode will not display the retailer on the website at all. I then added the retailer zip code 3 times and of course when checked all 3 displayed.

Finally when I deleted the two extra entries, the data displayed properly on the website. There are about 100 retailers in the table and this issue has only happened twice.

Any ideas?

Thanks for any help.

[jburfield]

Does the query you are using employ more than one table? Are you sure the data you need for each record is being populated into each table that you need?

For instance, if you have a table for company info and another for what they sell (just making this up here), and when you do the query you pull from both tables (joining them), make sure that the info for the new records is actually in both tables. If not, the join will not work (assuming straight join) and the record you are looking for will not show up.

Just a thought...I've see it happen before.

[Gina]

I have a total of 3 tables.
1. All US Zip Codes with latitude and longitudes.
2. All retailer address, name, zip codes.
3. Retailer2 (retailer table + lat and long from zip code table)

The updates are made to the retailer table. Once those updates are made, the client clicks a link that first drops the current retailer2 table and then rebuilds the table using all the data in the retailer table and the latitude and longitude from the zip code table.

(It gets a little complicated, but it speeds up the query on the website if we are searching one table with only the necessary zip code information instead of the entire US Zip code table and matching it to the retailer table and then performing calculations for nearest retailer.)

The first thing I checked was to make sure that the zip code was in all 3 tables and it was there.

I wonder if there is a problem within PHP that may cause this. I have a simple select statement on another website I had worked on and on some of the queries, I had to call the first field in the table twice so that it would display, but I have not had any problems on that site with the updates.