Selecting records based on ID

[eluser]RS71[/eluser]
Thank you mates!

Worked like a charm

Might I ask another question?

Lets say I want to delete all rows associated to a certain ID and replace them with a new set of rows. Is there a better way to do this other than a DELETE then a INSERT VALUES (...)?

Also, can I SELECT multiple rows from multiple tables in one query? I don't necessarily want to concatenate the rows returned from the different tables.

For example, lets say I have a table listing the user's favorite 'Books' and another for 'TV Shows'. How can I select all rows from 'Books' and all rows from 'TV Shows' belonging to a certain user in one query?

Thanks once again!