fenway

This seems like the 3rd separate thread you've posted on the same topic...

Incidentally, paddyhaig, I asked you to post the PM here -- and you didn't. So clearly, you're not really all that good at following instructions. But you're really good at insulting people at will. I'm sure these skills will serve you well.

What kind of error? From what?

Always.

Being mean in private is different than being mean in public. If you have an issue with Thorpe's PMs, then you need to resolve that with him. If you don't think that's possible -- and you'd be incorrect to assume so -- then feel free to post the offensive material so that we can judge for ourselves.

I've read through a few exchanges, and I don't see it.

That's php code, not a mysql query. Echo the actual query.

Well, does that query use an index?

Don't double post.

That's a permission thing.

You need to sort out if it's mysql or php that's not working.

TEXT is not particuarly efficient -- probably a VARCHAR of appropriate length.

I'm guess 2 would be preferable.

That's probably because they share a pointer. Never use mysql_result(), and you'll be just fine.

Really? No strange bugs?

You'll need to inspect the type of each column in the schema.

1) You have no WHERE clause with your UPDATE statement -- hope you had a backup. 2) You can do this with a single query.

Don't post your scripts unless you're asked to -- and you never will be. "Not displaying a page" is php, not mysql.

You're not using any indexes -- ever -- why not?

You should be just fine -- don't worry,.

You really don't need anything fancy -- trust me. If you want fast indexing, roll your own, or use Sphinx.

You need LIKE, not =

Well -- are you closing the connection at the end of your script?

That's because you're using a reserved keyword as a field name -- don't do that.

MySQL doesn't do any formatting -- that's up to you in php code.