fenway

there's nothing "new" -- just escape special characters.

Depends on you're able to connect to the former.

I don't see the suggested code in your sample.

Why corrupt the imdb database? Can't you just use those table locally?

"Parameters"?

Yeah, you have two commas there... but if WP is to blame, yell at them!

Why not join the tables?

Huh? Just have your script check against a "magic value" and switch the flag.

Try: select * from groups as g inner join members as m on ( m.group_field = g.name )

Not so simple... mysql has some great dev articles, that's a good place to start.

Rmove the word "TYPE".

MySQL has an INTERVAL for use with DATETIME fields. e.g. yourDateField - INTERVAL 1 HOUR

How about posting the solution for the rest of us.

I was confused by your query which has variables for the table names. You want to start with something like this: SELECT * FROM cases AS c INNER JOIN case_procedure AS cp ON ( c.id = cp.case_id ) INNER JOIN procedures AS p ON ( p.id = cp.procedure_id ) WHERE cp.procedure_id = '12' As you can see, your query was missing a join condition on what you call table "3", which likely resulted in duplicate records -- why was it there?

Check the EXPLAIN of each and you'll see.

JOIN syntax is a mysql issue... how are your three tables related?

Sounds like a concat might have worked...whatever.

Re-write that query with proper JOIN syntax and we'll take it from there.

Post INSERT statements here... don't take this topic offline.

You can use INSERT IGNORE.

You have some quoting issues.

Start with a hello world PHP script.

Lots of resources available on the stickies.

And LEFT JOIN ... IS NULL would be better, but your syntax is correct.

Convert from what?