PHP的mysql语句

基于ThinkPHP框架上的一条这样的语句
$voList = $pairing->query("select e.id,c1.name as bname,c2.name as cname from mmo_lmessage c1,mmo_lmessage c2,mmo_pairing e where c1.id=e.itemid and c2.id=e.pairid and type=1");

谁帮我转换为Join的语句 谢谢！

或是该如何使用Page分页

$sql = "select e.id,c1.name as bname,c2.name as cname from mmo_lmessage c1,mmo_lmessage c2,mmo_pairing e where c1.id=e.itemid and c2.id=e.pairid and type=1";
$sql = $sql." LIMIT $p->firstRow".",$p->listRows";
$voList = $pairing->query($sql);

这样就能分页了

if($_post['submit']){<br>$sql="insert into table2(user,title,content,lastdate)values('$_post[user]','$_post[title]','$_post[content]',now())";<br>mysql_query($sql);<br>echo "<script language=\"javascript\">alert('发表成功');history.go(-1)&lt;&#47;script&gt;";<br>}