in reply to 2 mysql selects in one statement

It would really help if you would brush up on your SQL-skills, because even those simple SQL-statements you wrote aren't valid SQL at all.

SQL-course isn't a bad place to start.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law