Hai there
I have a problem...if anybody know how to settle it tell me..ok
Here is my problem
I have 2 table in same database
Table One : AddressBook
value:
ItemID bigint(21) PRI
OwnerUD varchar(80)
Nickname varchar(20)
Email varchar(64)
Name varchar(64)
Note varchar(64)
gid bigint(21)
Table Two : Detail
value:-
ItemID bigint(21) PRI
f_Name varchar(30)
.
.
.
end
How i want delete this two tables at the same time
i have using this command but its not works
Delete FROM AddressBook,Detail WHERE ItemID='$id' OR AddressBook.ItemID = Detail.ItemID ;
The data in tables Detail will be delete if it's there if not it only will delete data in table AddressBook that why i'm using OR command
OK Thank to anybody that can help me..
I have a problem...if anybody know how to settle it tell me..ok
Here is my problem
I have 2 table in same database
Table One : AddressBook
value:
ItemID bigint(21) PRI
OwnerUD varchar(80)
Nickname varchar(20)
Email varchar(64)
Name varchar(64)
Note varchar(64)
gid bigint(21)
Table Two : Detail
value:-
ItemID bigint(21) PRI
f_Name varchar(30)
.
.
.
end
How i want delete this two tables at the same time
i have using this command but its not works
Delete FROM AddressBook,Detail WHERE ItemID='$id' OR AddressBook.ItemID = Detail.ItemID ;
The data in tables Detail will be delete if it's there if not it only will delete data in table AddressBook that why i'm using OR command
OK Thank to anybody that can help me..