fenway

You need to use %s in your query.

But why don't you get the _client_ machine to use the new protocol.

Have you read this?

You need to consult a php/mysql tutorial... you're trying to mix CLI syntax with PHP, and it's just a mess.

Post the code that you're using to prove this.

Is it your server? If not, get this to tell you what to do. But it sounds like you have the wrong password.

Get what? Your query makes no sense -- WHERE cImage?

Well, a multi-valued INSERT would be faster... but I'm not sure I see what the problem is.

I don't see any sql.

Why not have a unique key that spans both columns? Alternatively, what's wrogn with having multiple rows for each addition?

How could we possibly guess why the host is acting funny? Besides, are you sure it's not just the front-end?

Why not?

If you set the client timezone differently from the server timezone, mysql will do this for you.

Assuming you know the order of your array, you can simply used a multi-valued insert statement.

Wow, you could acutally make sense of that code?

the %s is a sprintf substitution marker... that is replaced with $colname_rsPtInfo... but then there's no "%" in the mysql query. You'd need: $query_rsPtInfo = sprintf("SELECT * FROM PtInfo WHERE Last_Name LIKE '\%%s' ORDER BY Last_Name ASC", $colname_rsPtInfo);

MyISAM has checksums....

That subquery should be fine... if you replace it with ( SELECT <some libNum that exists> FROM finishedLibs ) does it work?

Obviously, that machine has the old client software -- upgrade it.

Please re-read my previous posts. You're clearly confusing your HTML "rows" with your DB "rows". I have no idea what the checkboxes are for, how they get populated, or where they get saved.

This makes no sense -- you don't have a column called checked; and your life will be much simpler if you use different quoting inside & out.

You don't need % with AGAINST

Seems like you could combine some of these.

Not sure, this is a PHP-related issue now (file host permissions, not mysql, at least), so I'm moving it to the appropriate forum.

Use add it to the where clause... with AND. I assume you tried and it didn't work?