Review Table fields

[Tim_L]

This should probably be in this forum - sorry:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10246110

Any ideas?

[ultraslacker]

Take a stab at the reviews table and post it - in fact, you should post the current database design.

[Tim_L]

MY PRODUCTS TABLE:

PID
prod_name
prod_price
etc

MY REVIEWS TABLE:

ID
Author
Review
etc
PID

In my SQL statement I did an INNER JOIN as someone suggested:

SELECT *
FROM products p INNER JOIN reviews r ON p.PID = r.PID
ORDER BY p.title 

However, the one review in the REVIEWS table shows up on every product page instead of just the one specified in the PID in the REVIEWS table????

[ultraslacker]

You may need to replace author with foreign key userid to relate to a user table as well.

As far as the query, the sql is correct - you are returning all rows for matching PIDs. To find the problem, execute the query directly on the backend (either thru mysql client or some admin app) and analyze the results. If the data is fine, then it's likely the presentation code.