How to show the difference between two data field in a database with php.

[salman1]

Hello php gurus,

 

how r u all... i'm not so well facing a typical problem  :'( plz help me...

i'm working with php and mysql.

 

my problem is...

in a data base have two integer field like parent_id & child_id. i want to make the difference between the data of the two data field. such as...

table name: tbl_something

field name: parent_id  and child_id

data in the field like this: parent_id: 10,12,13,14,15.  and child_id: 10,11,13,14,16.

by making the difference between them my wanted result will be like this:

different parent id=12,15 and different child id =11,16.

 

plz if any one can help plz help... i'm in very problem.

 

thanks all of u.