I have a users table, i need to retrieve address,phone and email of a user where columns having address_type = 1, phone_type=1,email_type=1. ('_type=1' means present user using details and others are unused and archived records)
Below is my table structure
From above table i want to get address,phone,email of user_id=1 and where conditions are address_type=1, phone_type=1,email_type=1
Any help would be great..
via Guru
