Jessica

Then use AND. Come on dude. Like I said, basic MySQL tutorials.

Well? You have a variable where you should have a function. You're also not checking for MYSQL errors.

You need to check for errors.

Clearly not. Sorry.

Use OR.

It's very basic. Find some mysql tutorials, and learn to read the mysql manual.

You're mixing tables and div, you have the logic but you're printing new table rows, and you're not using table cells. Clean up your HTML.

Add a WHERE clause to your SQL.

How should we know?

If they are related in a logical way, just write the logic down. For example my foreign keys are always tablename_id. If I see that I know it's related to tablename

Inner/left join. Moving this to mysql section.

So you need to do it the same way I did in my thread. That's why I linked it. You need to structure your query the same way, because it's the only way to do that.

isset() just tells you if it exists and is set. You then compare the variable to the value you want to check as a separate evaluation.

Did you read the sticky on this topic? You appear to have whitespace at the beginning of the file.

Then you clearly don't know what that phrase means.

Careful with YOUR words. FYI.

You need to limit the join to the exercises table on which two exercises you want. It looks like you're getting every single exercise.

ROTFL. Yes, your life would be easier if we just did it for you. Too bad for you this is FREE HELP and we actually expect you to HELP US HELP YOU. I've asked you at least FIVE questions you haven't answered fully, I've given you a thread that describes IN DETAIL how I solved this problem (if it IS the same problem, you haven't given enough INFORMATION for me to be sure), and you refuse to actually do any of the things we suggest. Why do *YOU* bother? You clearly don't want to be helped. Why did you bother posting this? Life is so much easier when PEOPLE HELP THEM GOD DAMN SELVES. I'm so sick of people like you whinging for help and then when it's not handed to you on a silver platter in ONE FUCKING POST you blame US.

Good luck

FYI - you're acting like a child, and an idiot. Just FYI. You know. FYI. I never said you were using word. It was just an example. FYI.

If you want us to be able to help you you need to post your table structure, some sample data, and go read up on MySQL syntax, as well as probably some basic PHP syntax - like how $_POST is an array, not a function. It says Cannot Parse Query because that's the error message YOU'VE chosen to print when your query fails. You could get a much better error by using the tips in my Debugging SQL post. But you haven't explained how your data is related so we can't help you. There's a lot more to the post I wrote than just WHERE vs HAVING, you're not doing anything I did.

As to why your query is failing: AND tblDetails.DetailName = '$_POST('$selections') There are so many things wrong with that...

I don't see anything in there related to animals. This sounds very similar to a question I just asked. Read this and see if it helps. http://forums.phpfreaks.com/topic/274119-matching-a-one-to-many-relationship-exactly/