// ----------------------------------<br />// Give all the replies for this user<br /> $query = "<br /> SELECT t1.B_Number,t1.B_Subject,t1.B_PosterId,t1.B_Board,t1.B_Posted,t2.U_Number,t2.U_Username,t3.Bo_Title<br /> FROM {$config['tbprefix']}Posts as t1,<br /> {$config['tbprefix']}Users as t2,<br /> {$config['tbprefix']}Boards as t3<br /> WHERE t2.U_Number <> {$user['U_Number']}<br /> AND t1.B_Main <> 0<br /> AND t1.B_ParentUser = {$user['U_Number']}<br /> AND t3.Bo_Keyword = t1.B_Board<br /> AND t1.B_PosterId = t2.U_Number<br /> AND t1.B_PosterId <> {$user['U_Number']}<br /> AND t1.B_Approved = 'yes'<br /> AND t1.B_Board <> 'shoutboxpal'<br /> $groupquery<br /> ORDER BY t1.B_Posted Desc<br /> ";<br /> $sth = $dbh -> do_query($query);