fenway

What's a & b? use table aliases.

Why no where clauses?

What on earth are you talking about.

Are you capturing errors? Obviously, this isn't a transaction.

How?

show us your query

where is the join condition????

Unless you know the distribution in advance, you can't do this very easily -- you can kludge it, but it's not great. And lat/long is a completely different issue.

Anything specific?

If you want to do this, use ENUMs.

If the list of values is fixed, then SET would be fine... otherwise, use a separate table.

I see ALLs and FILESORTs...

I'm not sure what you mean... but can we see the error?

Listen buddy, watch the language... I told you before, you have to figure out why your table is corrupt. It's that simple -- and if you can't REPAIR it (and there are 5 version of REPAIR), you can have to restore it from backup.

Could you post the EXPLAIN of that query? Also, why not JOIN this dervied tables?

Be careful about magic_quotes, too... there was a nice clean() function floating around somewhere.

A primary key is simply a unique identifier of a record -- for example, if you had records with SSNs, you might not need to add a UID field (a.k.a. a surrogate key). As for the 2nd question, you simply need to join by following the *_id fields.

That depends how word interfaces with ODBC.

And if that doesn't work, show us the actual error.

The 2nd method also makes it possible to use multi-valued insert statements.

You can arbitrarily group things however you'd like, as long as you can come up with an expression that assigns each group a different value.

You mean like SELECT MAX(priceField) AS 'highest_price', MIN(price_field) AS 'lowest_price' FROM products

1 - you need to loop through all of the results in php, and then display an appropriate html block -- with substitution for the invoice #, etc. -- accordingly with variables. 2 - I'm not sure what you mean -- sounds like you need an invoice UID in the DB. 3 - Again, I'm not sure what you mean -- if you store your dates in YYYY-MM-DD (SQL-99) format, you'll have no issue whatsoever.

Are you using mysql_*, or mysqli_*?

Post the query you run vs. the query from phpmyadmin.