Thanks for that link!
I feel like I'm 60% of the way there, but I'm getting an SQL error
Instead of modifying product.php like in the exaple in the link above, I'm working in products.php (because I would like this to show on the products page, not so much in the individual product pages)
I was half expecting those two .php files to look similar since much of the data the output seems to be the same, but I was wrong.
Code:
#############################################################################################################
# Get the real manufacturer - This is a mod from the standard code
#
$thisManufactorer = $search_data["products"]["manufacturerid"];
$manufacturer = func_query("SELECT * FROM $sql_tbl[manufacturers] WHERE manufacturerid = $thisManufactorer");
$smarty->assign("manufacturer", $manufacturer[0]["manufacturer"]);
#
# End Get the real manufacturer - This is a mod from the standard code
#############################################################################################################
This is my slightly modified code that is giving me this error. The same error I had with the original code when used in products.php
Code:
INVALID SQL: 1064 : You have an error in your SQL syntax near '' at line 1
SQL QUERY FAILURE: SELECT * FROM xcart_manufacturers WHERE manufacturerid =
I appreciate any help offered!
Justin