fenway

Huh? That makes no sense -- are you actually executing all of them separately? And why have separate queries anyway?

Actually, you're getting a hash collision on the names... use column aliases and your problem will be solved. Try: SELECT CONCAT_WS( ' ', u1.first, u1.last ) as own1Name, CONCAT_WS( ' ', u2.first, u2.last ) as own2Name ...

What do you mean "resulting table"?

ok... then try: SELECT userid from myTable as t1 inner join myTable as t2 using ( userid ) WHERE t1.qid = 8 AND t1.answer = 'Female' AND t2.qid = 29 AND t2.answer = 'California'

That was the varchar limit until v5.

Nope, not on the list. Right, it's a function, that's it.

UID = unique ID -- I mean, a unique identifier for each row. And you're missing my point -- how do you know to look for 8 specifically?

Well, if you're actually importing that first row, mysql will barf.

Those are table aliases... try u1.first, u1.last, u2.first, u2.last... you'll see.

Is there a UID in this table? Where is the "8" coming from?

password is a reserved keyword, isn't it?

I have no idea... there's nothing "wrong" with the sql syntactically... if you can run it with navicat, then php is to blame.

that's a dependent subquery... no surprise.

You can use a REGEXP to match... but you shouldn't be storing data this way.

That doesn't answer my question... what do you want the output to look like?

That's single quotes... drop the quotes entirely. And don't use a CHAR() for your PK!

No problem.. everyone has to learn sometime.

That's still in double-quotes.

Most URIs are shorter than 255...

Huh?

It seems to me that you have a 1-to-many relationship with that other table, so obviously you're getting back multiple rows... Switch to inner join and try sq/sqa/sm -- without ss -- and we'll take it from there.

Which fields do you need from the 30-column table?

You should really join in the users table twice... ORs are bad. SELECT * FROM pages as p inner join users as u1 on (p.own=u1.id ) inner join users as u2 on (p.own2=u2.id )

Or use the CSV engine type.

Really? No kidding... well, then it's a php parsing issue -- try single quotes.