fenway

If you're not familiar with the I_S database, you should read the 5.1 manual... it's pretty fundamental to the way the server is run.

Don't double-post next time -- continue in the same thread; consider this a warning. I can't possibly imagine that PHP doesn't have a module for this; but how to escape it depends on what program is being used to read it. Usually, it's just adding quotes.

CSV is a very tricky format -- you need to escape any fields that contain the separator.

Echo out the sql statements and you'll see what's being actually deleted.

Since we don't see line numbers, and that's purely a php error, it's hard to say.

Use code tags next time. All you need to use is check each of the 3 fields, combined with ORs, if the user has provided any input.

That error is from some non-mysql, php wrapper.

Though 5.1 does have an event scheduler.

Solved how? You've started a lot of threads on what seem to be related queries.

I assume you solved this with a GROUP BY?

That's a bug in phpmyadmin, or your gzip isn't installed properly.

That's because you're using a signed smallint as you're primary key -- big mistake. Try INT UNSIGNED instead.

And why not a LEFT JOIN... iS NULL?

Huh?

You'll need to join it back after you determine the max.

That's not plain mysql -- I have no idea what those are.

Huh? I don't see any searching.

Sorry, did I not post the revised query?

What does the cnf file say?

???

MySQL can't help you there -- you'll have to write a stored procedure or do this in application code.

Sorry, what are you trying to do? seems lke too many queries.

Well, if your pages take a long time to load, and the max_connections is set really low, it's possible.

Fields only have one value.

Yup.