Querying Multiple Tables and Paging the result

[jackiw]

Hello all,

Is there any way I can do a multiple table search and page (next | prev) the results? I only know how to do it with single table.

Thanks a lot.

[leatherback]

Something along the lines of

select * from table1, table2 where table1.id = table2.table1identifier order by table1.id limit $start $limit

Make your for & next buttons just as you would with one table.

Hope this helps,

J.