fenway

Sounds like you need to trace your code.

What's a "particular php"? If you mean the whole page, that's not helpful.

That's quite tricky, since you have no other source for those zipcodes other than user input.

What errors?

You called your table "table"? Bad idea -- don't use a reserved keyword.

That's ALL of your code -- try again.

Why not just a simple JOIN?

That leads me to believe that it's in your table twice -- or that you're not excluding the same ID from both tables.

Have you tried running this in a query browser? I think it may be a quoting issue with your db class.

Why not store NULL as the discount price if it's "0", as use IFNULL()?

Then how can you ever have the parent node come back twice?

Search engines can follow any links from any reachable page -- or via a robots.txt file -- so yes, these can get indexed even if they're dynamic. But it's easy to workaround -- just assign a unique "named" url to each page, and lookup by that instead of, or in addition to, uid, and then use these as your page links.

And what does the source data look like?

Say what?

How about dumping mysql_error()?

First, you need to JOIN the tables; then you can filter out the rows you don't want.

mysql saves it as blank instead of as Null? And I'd like it to be Null if the data provided is left blank? Then show me the line that you think is translating this incorrectly.

Well, the whole idea of caching is that it's faster -- and if your web server just serves up a static html page, rather than having to connect to a DB, it'll be much faster -- so MEMORY isn't going to help much.

What query is pulling back these duplicates? Or are there actually duplicates in the recordset?

No without stored procedures there isn't.

Double -post.

Huh?

You can't combine LIMIT and JOIN -- you'll have to figure out which 10 you want first.

I don't follow.

There are stickies that talk about retrieving such data.