fenway

Barand's in a good mood this week -- this usually isn't the place if you want someone to write a script for you.

If you're talking about important data, then the source of the data isn't really the effortful part here.

I don't see how you've isolated MySQL as the culprit here -- check the output HTML.

Auto-increments means "I don't care about the value you choose".

This really up to the driver -- MySQL faithfully returns types.

LAST_INSERT_ID()

Don't post the entire code; you've been asked to show errors as well as table structure, but you're provided neither.

You can't apply DISTINCT to a particular column -- it operates at the record-level. What are you trying to do?

Didn't want to open a new thread just to drop a note that I'll be AWOL for a week or so.

Save what? The binary contents?

Are you you're accessing that recordset correct? Try vardump.

Are you asking us what a PHP function is?

And please stop posting all of your code unless it's directly related to the error.

Well, you're trying to use the alias of a colum in the SELECT list in the ON clause -- but the aliasing happens on the return, long after the JOIN.

What's more, all the counts from the same table can likely be cominbed.

Well, if you have binary logging / query logging enabled, you'll have something useful -- but the records are gone.

That's what mysql_error() is for. But the real issue is that you're confusing backticks and quotes -- ` is not the same as '.

Why would you randomly delete a file created by mysql?

1. Well, '%' includes localhost, but typically localhost permissions are less restrictive. 2. Yes, IP would be the best way to go -- usually, web users connect from your web server to your DB server -- and the former almost always has a static/virtual IP (or small range). 3. There is no such inheritance -- one sets of privs for each user/host. More restrictive first, IIRC, in terms of host.

@ignace -- I'm sure this is one of the preferences -- it's just that I wasn't expecting to see your name attached to them (yet).

Double-post -- topic locked.

You already posted this topic -- I've removed the other once, since this is clearer. But I still don't understand -- are you asking us to write the update/POST steps?

That explains all the user warnings e-mails I've been getting all week....

Describe this "piece of data".

Well, it's clear that whatever you think PDO is doing to that query, it's not -- there is no colon in the column name.