PHP MYSQL Query

[paparts]

Hi guys can i ask a help about this query.  I have 3 tables and I need to have the output on the image.  Thanks in adv. Attached is the image and a clearer view of the problem

 

[attachment deleted by admin]

[Ken2k7]

SELECT CONCAT_WS(' ', t1.fname, t1.lname) AS name,
           t1.address AS Address,
           t2.pname AS `Product Bought`
FROM table1 t1
INNER JOIN table3 t3
     ON (t1.user_id = t3.user_id)
INNER JOIN table2 t2
     ON (t3.prod_id = t2.prod_id)

[paparts]

 

select * from
    table1 t1
    table2 t2
    table3 t3
where
    t1.user_id = t3.user_id and
    t3.prod_id = t2.prod_id;

 

same as what I have.  I am having troubles with my pagination because empty fields are displayed.

[luca200]

Empty fields?

What do you mean  ???

[paparts]

I have 3 data on the table and when I used the queries it displays a lot of pages with empty data. but on the first page it displays the 3 data and on the 2nd page its displays blank.  I wonder why but anyway thanks a lot for the replies.  Consider this post solved thanks....

[Ken2k7]

What do you mean empty data? Are the rows empty or just a column?