fenway

It's not worth doing it yourself... you can get cheap hosting packages for <$10 a month... so why bother?

No, not temporary... write the query to get all of the related products that you need to query, and then use that "as" a table for the join.

Sounds like a slow connection...

You might as well run a query to get all the product and "related" product ids, then join onto that derived table.

Look into the UTC versions.

Do you use replication?

Why would you search the whole table to match a single record? Use a WHERE clause.

How can one product have multiple ids?

Use TRUNCATE TABLE if you want to delete everything -- otherwise, leave the auto increment field alone.

Well, I'm not sure why you're using AND... how are these tables related?

WHERE id IN ('3','4','5')

Sounds like missing POST data.

That's not plaintext... that's php.

GROUP BY?

Not really... your variable is nothing.

Sounds like you might actually be on a different box/ip...

Well, you can't stop the upload server-side, since it's asynchronous... but why not just reset the src of hte iframe?

You can't do multiple queries... just build a hash in php and run it in a loop. You could do this in mysql directly with a bunch of case statements, but what's thepoint?

That's the definition of random.

Why not store the date of the last read?

If you're not actually using the innodb features in your application, you can convert to back.

I'd like to see the actual query in plaintext... besides, why are you retrieiving all of the recordset and then just using the number?

I'm not sure part of this is database related ... how you display the image and showing the description is php/html.

What do you mean "is blank"? Like there's no row? Then you need a left join...

Whatever table you're designing, it's wrong.