fenway

The problem is that you upgraded to mysql 5 without reading about how the comma order precedence changed. You can't mix this with JOIN anymore the same way.

Well, let's see the EXPLAIN output of some of your queries.

Simply creating the table won't solve your problem... a missing table likely has missing data.

It will match by whatever you ask it to match.

Yup... but your script might timeout, so be careful.

There are some excellent stickes on this topic, too.

v5.1 has an event scheduler...

I mean joining them in the query, not in the actual tables...

You need version 4.1 to use subqueries, AFAIK.

So you should be able to get all of this back from a single query by joining the relevant tables...

select <column-list> from register_account where id='$afso_userid' union select <column-list> from activity_table But it's very dangerous to do this without explicitly listing the column names in both!!!!!!!

This isn't a mysql question.

It's my.cnf, not my.conf.

This is degerating into a purely php issue -- and it's about to be moved.

Because not all postal codes are number, and phone numbers have meaningful substrings. Since you'll never be able to meaningfully sort by either, there's no point. Because it's very poor w.r.t. performance.

You'll need to LEFT JOIN the products table to the mechanisms table... if products.mechanism_name isn't null, show a link.

You need a while() loop to iterate through the rows.

int(20) doesn't actually do anything... not as far as the data are concerned.

Nothing wrong with leaving them out around numbers, but only if you hard-code the numbers and they never come from user input -- which is why it's just easier to quote everytning.

Quote your variable.

Why not just SELECT task FROM ______ WHERE user='user' And figure out what tasks they completed?

Sounds like a good idea to me.

How did you make this estimate?

Don't store postcodes or phone numbers as INTs. Don't use TEXT fields. And make sure you pick reasonable lengths.

That's very specific.