mysql - retrieving information from 3 tables -
i have 3 tables: users: +----------+-----------------------------+-----------+ | users_id | user detail | otherid | +----------+-----------------------------+-----------+ | 1 | user name or details | 1 | | 2 | user name or details | 1 | | 3 | user name or details | 4 | | 4 | user name or details | 1 | | 5 | user name or details | 21 | | 6 | user name or details | 2 | +----------+-----------------------------+-----------+ photos: +----------+----------------+-----------+--------+---------+--------------+ | photosid | url | title | userid | likes | remarksid | +----------+----------------+-----------+--------+---------+--------------+ | 1 | 7459.jpg | title | 1 | 150 | 255 | | 2 | 7510.jpg | title | 1 | 146 | 247 | | 3 | 7460.jpg | ...