Delete Form Two Table

[aboughaly]

i have 2 table i need to know how to delete from

im insert All of member data in table Member and in same Time insert the Email only of user in Tablt maillist
All that Its Oky

But when i delete User by

mysql_query("delete from memeber where ID=$c[$i]") or die(mysql_error());

But Email still in maillist table

in need to know how when i delete user form my CMS its delete His Email Form Maillias Table

any help ?

[devphp12]

hi

u have ny binding with member n maillist table?

if not then ny uniqueness of email for all user?

if both are not then u cant

[aboughaly]

in relation between table ?

so what i must do for future to not make that again ????

sorry can explain in code ?

[devphp12]

hi
for that wen u make db
then keep field like this

member
ID,Name,Add,Contact

emaillist
userid.email

n chk b4 entry in maillist,email is not empty