fetch data from two tables in mysql

[priya gogte]

Hi all,

I am using where clause in my select query and want to display that database with pagination, but it is not done correctly.Please help.

$SQL = " SELECT count(Interview_Id)AS Total
FROM Interview_Master
JOIN
interview_questions_details
USING (Interview_Id)
WHERE
(First_Name_Of_Interviewee='$names[0]'
AND Last_Name_Of_Interviewee='$names[1]' )
OR Client_Name='$_POST[cname]'
OR Date_Of_Interview='$_POST[cid]'
OR Type_ID='$_POST[toq]'
OR ((First_Name_Of_Interviewee='$names[0]') AND (Client_Name='$_POST[cname]')) " ;