fenway

You're right... so don't use "*", ask for the fields you want back so that they "line up".

Let's keep the discussion to the boards, please.... You're LEFT JOIN-ing the ad_log table, so you need to move any conditions (like sess_id) to the ON clause, not the WHERE clause, or you won't get the "0" you want. It's that easy.

If you deleted the table, the query cache would be purged... something else is going on.

Post some sample data.

Why is your variable not being interpolated? Isn't it in double-quotes?

I don't see the purpose of the group by, since it's on an ID field, and will do nothing but slow down the query. And if it were on a non-unique field, the non-group'ed by fields would be meaningless. If you were running this in MySQL 5 with strict mode, mysql would complain.

Um, you can't group by something and then retrieve a whole bunch of other fields.

Well, if you can't unserialize() in mysql, then you're stuck.

I don't know what you're trying to do, but IF() expressions can help in sql.

Where is it?

I'm confused by the math... what are you trying to count? And for SUM, why isn't the difference inside the parens?

Apprecitaed.

Yes, it would be... I'm actually surprised they still use the old libraries. Can you simply update the password with OLD_PASSWORD()?

Well, you're not catching mysql_error() after that query... echo $sql.

It's called my.cnf (Linux) or my.ini (Windows), usually in the home directory (Linux) or the Windows directory.

Well, the best option would be to get the new client libraries... can you do that?

Echo the $sql variable in PHP... and I assume you're catching errors in mysql_query() and checking mysql_error().

This has nothing to do with ASP vs. PHP... you simply have old client libraries for mysql... see this link.

Could you echo sql?

Not sure how that would have solved it.... but servtype can't be equal to 2 things at once!

You can change this limit if you have control of the server....

.... like not inserting any data, for example.

Which query is generating that error?

Could you please post your solution for the benefit of others?

Assuming there are myISAM tables