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?

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.

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?

Agreed -- done.

I've heard nothing but horror stories about them.

Covers: Part 1: Using the MySQL Improved Extension, mysqli Part 2: Using the MySQL Extension, mysql Part 3: Using the PDO Extension With MySQL Driver, pdo_mysql Part 4: Using the MySQL Native Driver for PHP, mysqlnd Tutorial is here.

Well, a scalar subquery, that is.

Hopefully this presentation will stay online at scribd... it's simply fantastic, probably the best I've come across in recent memory. At 220 slides, it's quite lengthy -- but the lessons learned are invaluable, so be sure to read all the way to the end. A MUST READ!!!! EDIT: This year's version of the presentation -- some really great stuff in here, particuarly about hierarchies.