Weetat, Can you be clearer, and then I might be able to help. Do you just want to perform updates towards the database? What is the status field? /Peter -----Original Message----- From: weetat [mailto:weetat.yeo@xxxxxxxxx] Sent: Wednesday, June 07, 2006 2:36 PM To: php-general@xxxxxxxxxxxxx Subject: how to compare value between 2 arrays Hi all, I am using php 4.3.2 in Red hat enterprise. Have some issue which need some advice from php experts here. I need to compare value between 2 arrays . The arrays data are populated by data from the database resultset. The database resultset fields are the same type and name. for example , serial_no is PK field. in resultset 1 , have field serial_no = '123456' country = 'England' and city = 'London' in resultset 2 , have field serial_no = '123456' country = 'England' and city = 'Manchester As you can see , the city value is different between the 2 resultset. So i will update status fields in the resultset 1 to 'Update'.If the same is 'New' ,and so on. Thanks -weetat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php