fenway

Are you really asking us what "case-insensitive" means?

FULLTEXT is funny -- depends how common these phrases are.

The refman is your friend.

Then read up on the mysql_* functions in the php refman -- it seems to be igonring you.

No, it doesn't -- just wait until you input has a comma, or you have "John" and "Johnson".

I'm not sure I follow -- (a) you're only asking for "theID" -- don't know what it is -- and (b) check how many matching records actually exist.

It's called a JOIN.

Huh? Dump the recordset.

Don't store delimited values in a single field.

The sticky has some great resources on various hierarchical table design considerations.

This has to do with php's mysql functions, not the mysql server.

I always use the equivalent of an activity column on every table that contains client data -- I can always backup or archive off-line.

STR_TO_DATE() works too.

That's a bad idea -- not thread-safe -- use auto-increment as suggested earlier.

A and C are identical.

No -- one table of answers, linked to question_id.

I see no errors posted.

Then you're still printing another header somewhere.

Why not a LEFT JOIN, then?

Um, a user_id column?

It'll annoy people, and then alot of people won't bother using the service if they can't get any help? If people expect ANYTHING in terms of reliability from a FREE service, they're fooling themselves. It's an illusion. Gmail can turn off tomorrow, delete all of your e-mail, not tell you, and it's your fault, not theirs. Well if Gmail did close tomorrow they would be up for a lot of legal costs as part of the gmail contract is that they will provide 99.5% uptime and if they break that contract a lot of people would sue google. As it is people almost sued google when did went down for a few hours but google argued because it only effected 25% of the customers therefore they could be down 4 times the time mentioned on the contract. Lucky <blank> See Mchl's post -- Google owes nothing to anyone.

It'll annoy people, and then alot of people won't bother using the service if they can't get any help? If people expect ANYTHING in terms of reliability from a FREE service, they're fooling themselves. It's an illusion. Gmail can turn off tomorrow, delete all of your e-mail, not tell you, and it's your fault, not theirs.

Or what? It's a free service.

Not sure what you're trying to do... multi-valued insert statement?

Don't store comma-separate values.