Join Statemetn to show image
The print work great! Thank you!
The Column 'adid' in order clause is ambiguous - I have zipped my attempts and here are the live pages:
ads_horses_results-ORDERBYadid.php
My most recent attempt show one horse repeating - ie only the 1st matching horse in the database I assume.
ads_horses_results.php
On this file I added a filter to just display ads with images
"SELECT ads_horses.*,tbl_posts.* FROM ads_horses INNER JOIN tbl_posts ON ads_horses.adid = tbl_posts.postid WHERE ad_category = '3' AND image IS NOT NULL AND image <> '' ORDER BY postid DESC"; so we could see just ads which have images and also ad_category is the id for the ads_horses
I also added this and the price and customer ID does not display, looks like nothing from the tbl_posts is displaying.
Customer ID: {WADAads_horses.customerid} ${WADAtbl_post.price}
I thought I had this working right away by simply changing the ORDER BY to postid, nearly sure I did. Therefore I tried again with
"SELECT ads_horses.*,tbl_posts.* FROM ads_horses INNER JOIN tbl_posts ON ads_horses.adid = tbl_posts.ad_category ORDER BY postid DESC"; Because the ad_category is the field that actual is common between the 2 tables, but here the image does not show up at all. Nor does the price or customer id
ads_horses_results.php
The FTP info is in message 8 on closed ticket #146365
Thank You!
