delete entry from multiple tables

Hi guys,

I just wanna is there anyway i can use sql query to select from all table in a database where the id = 'name' ???

for insntance, my client's name is John,, we have kept his data in 6 tables under the same database... is there anyway i can use a single query so that i can display or delete all his data from the table that contain his info ?? or is there any other way i can do to perform such a task ??

i wanna do this by using phpmyadmin...

p.s: if i wanna do this by using php, is it what i have to do is just performing multiple mysql_query() ??

please advise..

How come you've got his data duplicated so many times?

I imagine you'll just need to do multiple queries.