PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- $sql_msg_profile = "
- SELECT profile_user.id, profile_user.name_user, profile_user.family_user,profile_user.ava_user,
- msg_users.msg,msg_users.date,msg_v_i.id,msg_users.readed
- FROM msg_v_i,msg_users,profile_user
- WHERE msg_v_i.id_ot = :id_us1 AND msg_v_i.id_pol != :id_us2 AND msg_v_i.id_pol != 0
- AND msg_users.id = msg_v_i.id AND msg_users.from_user = msg_v_i.id_ot AND profile_user.id = msg_v_i.id_pol
- ORDER BY msg_v_i.id DESC LIMIT :cursor , 20";