View Single Post
  #3  
Old 03-12-2011, 12:14 PM
 
jeremyScott jeremyScott is offline
 

Advanced Member
  
Join Date: Dec 2008
Posts: 39
 

Default Re: Manufacturer Name in products_list.tpl

hmmm, tried that with no luck.
I realized that I have a table prefix of xcart_ on all of my tables, so I made the change in the 2nd line of your code, but still haven't had any luck.

PHP Code:
$thisManufactorer $product_info["manufacturerid"];
$manufacturer func_query("SELECT * FROM $sql_tbl[xcart_manufacturer] WHERE manufacturerid = $thisManufactorer");
$smarty->assign("manufacturer"$manufacturer[0]["manufacturer"]); 

Also, I wasn't getting any sort of feedback that this was even working until I put this code in 'products.php' not 'product.php'. When I put it in products.php I was getting this error;
Code:
INVALID SQL: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE manufacturerid = ''' at line 1 SQL QUERY FAILURE:SELECT * FROM WHERE manufacturerid = ''

I tried wrapping $thisManufactorer in quotes but that didn't help either.
__________________
X-Cart version 4.3.2
Reply With Quote