Help me to build a query

jacob_kochi

I have two tables
1. Userlog
2. User profile

User Log

id :name

5 : username1

6 : password2

User profile

id :userlogid :locationid

1 : 5 : 33

2 : 6 : 44

I want to delete all record where location=33(userlog-id and user pofile--userlogid are related). when deleting records in "user profile" table i must also delete the correspoding record in "user log" table. Can I do this in one query(Mysql)

planetsim

Yes you can..

jacob_kochi

Pleaase Help me

planetsim

Im not great with Mysql or SQL in that matter so im sure someone will out smart me here

mysql_query("SELECT table1.feild1,table2.feild1 FROM table1, table2 WHERE location=33 AND table1.feild1=table2.feild1");

Now that wont work most likely but its something like what i do. Now dont doubt if someone does better.

jacob_kochi

it does't work for delete query

planetsim

woops

take select out try DELETE.
It probably wont work either. But like i said im not great with Mysql

jacob_kochi

Looking for operation similar to "cascade delete" in other SQLs

jacob_kochi

sssssssssssssssssss...............................