Вроде можно одним SELECT, с использованием JOIN
CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT t. * , c.id AS cid, c.firstname, c.surname, c.birth_day, c.passport_number, c.passport_info, c.address_info, (
- SELECT w.amount
- FROM withdrawal w
- WHERE w.product_id = t.id
- AND w.product_type =1
- ORDER BY w.id DESC
- LIMIT 1
- ) AS w_amount, (
- SELECT w.months
- FROM withdrawal w
- WHERE w.product_id = t.id
- AND w.product_type =1
- ORDER BY w.id DESC
- LIMIT 1
- ) AS w_months, (
- SELECT w.days
- FROM withdrawal w
- WHERE w.product_id = t.id
- AND w.product_type =1
- ORDER BY w.id DESC
- LIMIT 1
- ) AS w_days
- FROM tamasuki t, clients c
- WHERE c.id = t.client_id AND t.id=". $id . "
- GROUP BY t.id
- LIMIT 1