Quote:
Originally Posted by Kirk Fitzgerald
I have already tried to do it myself by searching the net for info chap and have failed, which is why I am asking the one guy who will know how to do it properly. I have absolutely no idea what most sites are going on about when they talk about mysql queries, let alone translating it to search for something in my own database.
|
A join brings two tables together... For example for your needs:
SELECT <all the existing fields>,user.userid,user.username
FROM " . TABLE_PREFIX . "pf_product.createdby = user.userid
JOIN user ON pf_product
You'd work this into the query in the hook showthread_post_start
If you have a closed area of your forum for products play around with the code. While I understand it's not simple templates the best way to take control is by tweaking which leads to learning.