Advertisement
Guest User

Troll

a guest
Mar 10th, 2013
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.60 KB | None | 0 0
  1. $query = $conn->prepare('SELECT * FROM '.$tb['msg'].' WHERE ('.$msg['to'].' = :partner
  2.                 AND  '.$msg['from'].' = :u_id) OR ('.$msg['from'].' = :partner
  3.                 AND  '.$msg['to'].' = :u_id) ORDER BY '.$msg['time'].' LIMIT (
  4.                 (SELECT COUNT('.$msg['id'].') FROM '.$tb['msg'].' WHERE
  5.                 ('.$msg['to'].' = :partner AND  '.$msg['from'].' = :u_id)
  6.                 OR ('.$msg['from'].' = :partner AND  '.$msg['to'].' = :u_id)),
  7.                 ((SELECT COUNT(*) FROM '.$tb['msg'].' WHERE ('.$msg['to'].' = :partner
  8.                 AND  '.$msg['from'].' = :u_id) OR ('.$msg['from'].' = :partner
  9.                 AND  '.$msg['to'].' = :u_id)) - 20)) ');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement