[Resolved] paginating data w/ inner table joins

[neo100101]

I'm having some trouble paginating data using an inner table join. I know that the query for a standard pagination would look something like this...

$query1="SELECT COUNT(*) AS Total FROM table WHERE terr_ID='$SESSION_TERR_ID' ORDER BY $ordertype $ranking";

but is there a way to paginate data after using a table join? I need the information off of both tables for the query and my table join looks something like this...

$query1="SELECT T2.ID, T2.pharm_ID, T1.activity AS Total FROM pharmacies T1 INNER JOIN pharmacist T2 ON T1.Ph_ID=T2.Ph_ID WHERE T1.terr_ID='$SESSION_TERR_ID'";

Does anyone know how to make such a paginating query work?

[ralphuk100]

I know its late, but what does the pagination have to do with your sql query?

[neo100101]

yep... but I found the answer, instead of using the COUNT(*) I used the mysql_num_rows(); to find the total number of records found for the joined table.

[ralphuk100]

the reason your inner join did not work is count * is ambiguous. You could either have changed to an outer join or done:

SELECT COUNT(tablename.*)

[neo100101]

cool, thanks for the tip 😃