-
Manufacturers All About Support
This thread is for support of the Manufacturers All About v1.0 mod (about to uploaded to plugins).
Description
Manufacturers_All_About combines and updates two previous mods - Manufacturers All Listing and Manufacturers About - and is particularly useful for stores engaging, or wishing to foster relationships with, third-party manufacturers.
Manufacturers_All_About generates two new pages - one to display a listing of all manufacturers in database table manufacturers and the other to display certain information about individual manufacturers. Both pages can display links to the manufacturer's products in your store and to the manufacturer's website. This mod also interacts with the manufacturers and manufacturer_info sideboxes.
The Manufacturers All page is accessed via links inserted into the Categories and/or Manufacturers sideboxes, or by typing into your browswer address bar: http://www.yourdomain.com/index.php?...ufacturers_all.
The Manufacturers About page is accessed via the Manufacturers and Manufacturers_Info sideboxes, and the Manufacturers All page.
Admin configuration options are provided under Admin > Configuration > Manufacturers All About.
Page layouts invoke tableless responsive fluid design principles, allowing the pages to fit various screen sizes without forming horizontal scroll bars, all of which is now controlled by CSS.
Cheers
-
Re: Manufacturers All About Support
Could someone please change the title of this thread from
Manufacturer All About Support
to
Manufacturers All About Support
thanks
-
Re: Manufacturers All About Support
-
Re: Manufacturers All About Support
Hi dw08gm,
im currently working on a site that will feature hundreds if not thousands of "manufacturers", I do intend to change this to "Artists" so that I can give each relevant artist their own individual page showcasing their own individual artwork. The page would have a personal profile with picture, etc. Your plugin seems like the perfect mod for that purpose and just wondered if you can see any restraints or limitations, or if indeed this mod is suitable for my purpose. Thanks.
Regards
James
-
Re: Manufacturers All About Support
Glad you asked. The mod does cater to such situations, although it does have limitations, like not having pagination to split up one long list into smaller (more managable?) pages.
I am currently working on an upgrade that includes:
1. ability to display/not display individual manufacturers (done, but has glitches)
2. ability to sort the display of individual manufacturers (done, but has glitches)
3. ability to not display product link if manufacturer has no products in store (in train)
4. pagination.
5. upgrade similar to zc153 admin/banner_manager.php
However, with limited coding skills, I am just plodding along, and would need help in order to get the upgrade out sooner.
-
Re: Manufacturers All About Support
Thanks for the quick response! It all sounds very interesting and may be what I'm looking for. AmI right in thinking that the listing page, although it has no pagination as yet, could be styled even as single page? Also, would the about page differ greatly from the standard manufacturers products listing page that lists their products when their name is selected? one of my thoughts was to give each artist an EZ page but this seams like the long way round when I imagine it would far easier to just modify the original code to add say a profile picture or bio to the manufacturers product listing page. Forgive my ignorance, I'm very new to Zen, but does this mod work along side the manufacturers product listing page rather than altering that particular page itself?
i hope that post made some sense mate as I've kind of confused myself with it. lol
-
Re: Manufacturers All About Support
The mod creates two pages as described in the readme.txt.
The manufacturers All page is currently a single page listing ie all manufacturers are displayed on the one page in column/row format. Each manufacturer is alotted limited space for name, image and three links below to about, products and url.
The manufacturers About page has provision for name, image, description (about...) and two links below to products and url. You do not need to created additional ezpages, but you can if you wish.
You are free to modify the code to your heart's content.
-
Re: Manufacturers All About Support
Thanks for the info. I reckon I'll me making use of this mod in the very near future. :thumbsup:
-
Re: Manufacturers All About Support
Upgrade Version 1.1 added to plugins.
Changes include:
fixed layout issues in admin manufacturers page
added admin/includes/languages/english/images/buttons/button_new_manufacturer.gif
added ID, status and sort_order columns to admin manufacturers page
added facility to sort by ID, manufacturers_name, status and sort_order columns to admin manufacturers page
added additional admin switches to Admin > Configuration > Manufacturers All About
added extra language defines to admin/includes/languages/english/manufacturers.php
added status function to admin/includes/functions/extra_functions/manufacturers_all_about_functions.php
added status function to includes/functions/extra_functions/manufacturers_all_about_functions.php
changed function zen_get_manufacturers_about to zen_get_manufacturers_info in includes/functions/extra_functions/manufacturers_all_about_functions.php
added extra language defines to includes/languages/english/ manufacturers_about.php and manufacturers_all.php
added status flags to manufacturers_all and manufacturers_about pages
added provision to display something in manufacturer_all and manufacturer_about pages when links to manufacturer_about and manufacturer_URL are left blank
added pagination code to tpl_manufacturers_all_default.php
added placeholders in admin/manufacturers.php for manufacturers_metatags mod by lat9
created new file includes/modules/manufacturers_all_listing_display_order.php to handle various manufacturers_all sort order display options
changed optional text in /admin/includes/modules/category_product_listing.php to reflect addition of ID column in admin manufacturers page
added manufacturers_status and manufacturers_sort_order fields to install.sql
cheers
-
Re: Manufacturers All About Support
Upgrade upload suspended until problem with the pagination code in modules/pages/manufacturers_all/header_php.php is resolved. It seems that the 'splitPageResults' code does not play nicely with 'select distinct' and/or 'order by'.
Code:
if (!MANUFACTURERS_ALL_EMPTY_SHOW) { // only display manufacturers with products
$manufacturers_all_sql = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and m.manufacturers_id = p.manufacturers_id
and m.manufacturers_status = 1
and (p.products_status = 1
and p.products_quantity > 0) " .
$order_by;
} else { // display all manufacturers
$manufacturers_all_sql = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and m.manufacturers_status = 1 " .
$order_by;
}
// bof Pagination
/*
$manufacturers_all_split = new splitPageResults($manufacturers_all_sql, MANUFACTURERS_ALL_MAX_DISPLAY, 'm.manufacturers_id', 'page');
if ($manufacturers_all_split->number_of_rows > 0) {
$manufacturers_all = $db->Execute($manufacturers_all_split);
while (!$manufacturers_all->EOF) {
$rows = 0;
*/
// eof Pagination
//replacing the above pagination code with the following two lines works but listing is without pagination
$manufacturers_all = $db->Execute($manufacturers_all_sql);
while (!$manufacturers_all->EOF) {
$manu_content .= '<div class="manuWrapper">';
-
Re: Manufacturers All About Support
Upgrade Version 1.1 added to plugins.
Fixed layout issues in admin manufacturers page.
Added 3 new buttons to admin/includes/languages/english/images/buttons/: button_new_manufacturer.gif, button_manufacturer_options.gif and button_admin_options.gif.
Added ID, status and sort_order columns to admin manufacturers page.
Added facility to sort by ID, manufacturers_name, status and sort_order columns to admin manufacturers page.
Added additional admin switches to Admin > Configuration > Manufacturers All About.
Added extra language defines to admin/includes/languages/english/manufacturers.php
Added status function to admin/includes/functions/extra_functions/manufacturers_all_about_functions.php.
Added status function to includes/functions/extra_functions/manufacturers_all_about_functions.php.
Changed function zen_get_manufacturers_about to zen_get_manufacturers_info in includes/functions/extra_functions/manufacturers_all_about_functions.php.
Added extra language defines to includes/languages/english/ manufacturers_about.php and manufacturers_all.php.
Changed SHOW_CATEGORIES_BOX_MANUFACTURERS_ALL to MANUFACTURERS_ALL_ABOUT_CATEGORIES_BOX_LINK in admin options and in includes\templates\YOUR_TEMPLATE\sideboxes\tpl_categories.php.
Added status flags to manufacturers_all and manufacturers_about pages.
Added provision to display something in manufacturer_all and manufacturer_about pages when links to manufacturer_about and manufacturer_URL are left blank.
Added pagination code to tpl_manufacturers_all_default.php. BUT THIS NEEDS TO BE FIXED AS DOES NOT WORK WITH "SELECT DISTINCT" AND/OR $order_by IN $manufacturers_all_sql. This also impacts the admin switch "Maximum Display per Manufacturers All Page", where changing the value has no affect.
Added placeholders in admin/manufacturers.php for manufacturers_metatags mod by lat9.
Created new file includes/modules/manufacturers_all_listing_display_order.php to handle various manufacturers_all sort order display options.
Changed optional text in /admin/includes/modules/category_product_listing.php to reflect addition of ID column in admin manufacturers page.
Added option to display link in admin/manufacturers.php to Admin > Configuration > Manufacturers All About configuration options.
Added manufacturers_status and manufacturers_sort_order fields to install.sql.
Added upgrade.sql.
Cheers
-
Re: Manufacturers All About Support
Using Zen Cart Version 1.54.
When I run the install.sql file I get these errors:
ERROR: Cannot insert configuration_key "" because it already exists- 12 times
ERROR: Cannot ADD column manufacturers_status because it already exists.
ERROR: Cannot ADD column manufacturers_sort_order because it already exists.
ERROR: Cannot ADD column manufacturers_about because it already exists.
ERROR: Cannot ADD column manufacturers_about because it already exists.
Note: 15 statements ignored. See "upgrade_exceptions" table for additional details.
Sideboxes are there.
Configuration/Manufacturers All About does not have any options????
Please help.
-
Re: Manufacturers All About Support
Seems like you ran the install sql more than once.
You could compare the manufacturers and admin_pages tables with the sql to see if the sql has loaded properly.
-
Re: Manufacturers All About Support
Quote:
Originally Posted by
dw08gm
Seems like you ran the install sql more than once.
You could compare the manufacturers and admin_pages tables with the sql to see if the sql has loaded properly.
I ran the install.sql and got these error messages the first time. I then ran the uninstall.sql and it worked fine and re-ran the install.sql again and got the same error messages. How about the fact that the configuration/manufacturers all about screen is blank except for the header information. No information below the header???? I will check the sql to the tables using myphpadmin and will report back.
-
Re: Manufacturers All About Support
Quote:
Originally Posted by
fjbern1943
I ran the install.sql and got these error messages the first time. I then ran the uninstall.sql and it worked fine and re-ran the install.sql again and got the same error messages. How about the fact that the configuration/manufacturers all about screen is blank except for the header information. No information below the header???? I will check the sql to the tables using myphpadmin and will report back.
OK Here is my report so far.
I checked the database in phpmyadmin and did not find the Manufacturers All info in the configuration group table but did find the info in the manufacturers_info table. Ran the install.sql directly in phpmyadmin and got an error referring to the info already in the manufacturers_info table. I took out that part of the install.sql and ran it again successfully.
Went to admin/configuration/Manufacturers All About and the configuration information was there. All seemed to be fine. Checked the Layout box controller and checked if both the manufacturers and manufacturers_info boxes were turned on. They were, however, the Manufacturers_info box does not appear in the sideboxes on the site, the Manufacturers box does appear. ???????
Also in database the manufacturers ID in the manufacturers_info table were not right. They showed numbers like 550011 for two manufacturers and the right ID for one of the manufacturers. Changed two of the ID's to match the ID's in the manufacturer table and was now able to edit the manufacturers in the admin. Then I noticed that the Admin Options link in the top right corner of the Catalog/Manufacturers takes me to http://localhost/shop154r/adminyukat...on.php?gID=999 ????????
Last but not least All information on the Manufacturers All page appears twice. You can see it at http://christianstore.biz/index.php?...ufacturers_all ????????
This plugin needs some serious repair. If I can't fix it with your help I will have to abandon its use, which I really don't want to do.
Please reply!
-
Re: Manufacturers All About Support
Quote:
Originally Posted by
fjbern1943
OK Here is my report so far.
I checked the database in phpmyadmin and did not find the Manufacturers All info in the configuration group table but did find the info in the manufacturers_info table. Ran the install.sql directly in phpmyadmin and got an error referring to the info already in the manufacturers_info table. I took out that part of the install.sql and ran it again successfully.
Went to admin/configuration/Manufacturers All About and the configuration information was there. All seemed to be fine. Checked the Layout box controller and checked if both the manufacturers and manufacturers_info boxes were turned on. They were, however, the Manufacturers_info box does not appear in the sideboxes on the site, the Manufacturers box does appear. ???????
Also in database the manufacturers ID in the manufacturers_info table were not right. They showed numbers like 550011 for two manufacturers and the right ID for one of the manufacturers. Changed two of the ID's to match the ID's in the manufacturer table and was now able to edit the manufacturers in the admin. Then I noticed that the Admin Options link in the top right corner of the Catalog/Manufacturers takes me to
http://localhost/shop154r/adminyukat...on.php?gID=999 ????????
Last but not least All information on the Manufacturers All page appears twice. You can see it at
http://christianstore.biz/index.php?...ufacturers_all ????????
This plugin needs some serious repair. If I can't fix it with your help I will have to abandon its use, which I really don't want to do.
Please reply!
OK I solved the manufacturers appearing twice on the Manufacturers all page by deleting the Spanish id in phpmyadmin for each manufacturer. Apparently the plugin is not setup for more than one language. Could this be fixed?????? Still no progress to get the manufacturers all sidebox to appear.
-
Re: Manufacturers All About Support
Seems to be working now, but what is the "\n" after the "Manufacturers All" link under your product listing?
Why not turn the "Manufacturers" sidebox heading also into a "Manufacturers All" link
-
Re: Manufacturers All About Support
Quote:
Originally Posted by
dw08gm
Seems to be working now, but what is the "\n" after the "Manufacturers All" link under your product listing?
Why not turn the "Manufacturers" sidebox heading also into a "Manufacturers All" link
The Manufacturers All link also had three periods which I got rid of by modifying the "tpl_categories.php file . I have no idea why the /n is there. As the mod author I thought maybe you could tell me.
Also your second comment "Why not turn the "Manufacturers" sidebox heading also into a "Manufacturers All" link", I ask how do I do that? I would certainly like to do that if I knew how.
Also no comments by you on the rest of my post??????
-
Re: Manufacturers All About Support
Quote:
Originally Posted by
fjbern1943
The Manufacturers All link also had three periods which I got rid of by modifying the "tpl_categories.php file . I have no idea why the /n is there. As the mod author I thought maybe you could tell me.
This is documented in the readme - optional edits #1a & 1b.
The place to edit the define CATEGORIES_BOX_HEADING_MANUFACTURERS_ALL is in your includes/languages/(YOUR_TEMPLATE)/english.php.
Quote:
Originally Posted by
fjbern1943
Also your second comment "Why not turn the "Manufacturers" sidebox heading also into a "Manufacturers All" link", I ask how do I do that? I would certainly like to do that if I knew how.
This is documented in the readme - optional edits #2.
Quote:
Originally Posted by
fjbern1943
Also no comments by you on the rest of my post??????
Because from what I saw of your site yesterday, you already seem to have the mod working as intended.
-
Re: Manufacturers All About Support
Quote:
Originally Posted by
fjbern1943
Apparently the plugin is not setup for more than one language. Could this be fixed??????
includes/modules/pages/manufacturers_all/header_php.php
Change from
Code:
if (!MANUFACTURERS_ALL_ABOUT_EMPTY_SHOW) { // only show manufacturers with products
$manufacturers_all_sql = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and m.manufacturers_id = p.manufacturers_id
and m.manufacturers_status = 1
and (p.products_status = 1
and p.products_quantity > 0) " .
$order_by;
} else { // show all manufacturers
$manufacturers_all_sql = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and m.manufacturers_status = 1 " .
$order_by;
}
to
Code:
if (!MANUFACTURERS_ALL_ABOUT_EMPTY_SHOW) { // only show manufacturers with products
$manufacturers_all_sql = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.languages_id, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and mi.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and m.manufacturers_id = p.manufacturers_id
and m.manufacturers_status = 1
and (p.products_status = 1
and p.products_quantity > 0) " .
$order_by;
} else { // show all manufacturers
$manufacturers_all_sql = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.languages_id, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and mi.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and m.manufacturers_status = 1 " .
$order_by;
}
To prevent the manufacturers from showing twice in admin
YOURADMIN/manufacturers.php
Change
Code:
// bof Manufacturers_All_About v1.1 also get manufacturers_info
// $manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";
$manufacturers_query_raw = "SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, m.manufacturers_status, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
FROM (" . TABLE_MANUFACTURERS . " m
LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
ORDER by $disp_order";
// eof Manufacturers_All_About v1.1 also get manufacturers_info
To
Code:
// bof Manufacturers_All_About v1.1 also get manufacturers_info
// $manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";
$manufacturers_query_raw = "SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, m.manufacturers_status, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
FROM (" . TABLE_MANUFACTURERS . " m
LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
WHERE mi.languages_id = '" . (int)$_SESSION['languages_id'] . "'
ORDER by $disp_order";
// eof Manufacturers_All_About v1.1 also get manufacturers_info
-
Re: Manufacturers All About Support
Thank you for your response.
Works llike a charm. Unfortuntaely due to other problems with having the site in Spanish with other plugins I have decided to remove Spanish from the site.
I do however still have one more problem.
Here is my setup: zc 1.54, Manufacturers _all_about 1.1, ceon URI mapping 4.x
The manufacturers site link on the manufacturers_all page works fine. However the manufacturers site link in the manufacturers_info sidebox does not. The sidebox link goes to http://http//mydomain.com/index.php?...(manufacturers ID number)
In short how do I get rid of the extra http//
Thanks in advance for any help.
-
Re: Manufacturers All About Support
includes/templates/YOURTEMPLATE/sideboxes/tpl_manufacturer_info.php
change about line 27 from:
Code:
if (zen_not_null($manufacturer_info_sidebox->fields['manufacturers_url']))
$content .= '<div class="manuInfoLink"><a href="http://' . zen_href_link(FILENAME_REDIRECT, 'action=manufacturer&manufacturers_id=' . $manufacturer_info_sidebox->fields['manufacturers_id']) . '" target="_blank">' . BOX_MANUFACTURER_INFO_HOMEPAGE_TEXT . '</a></div>';
to
Code:
if (zen_not_null($manufacturer_info_sidebox->fields['manufacturers_url']))
$content .= '<div class="manuInfoLink"><a href="' . zen_href_link(FILENAME_REDIRECT, 'action=manufacturer&manufacturers_id=' . $manufacturer_info_sidebox->fields['manufacturers_id']) . '" target="_blank">' . BOX_MANUFACTURER_INFO_HOMEPAGE_TEXT . '</a></div>';
-
Re: Manufacturers All About Support
Quote:
Originally Posted by
webchills
includes/templates/YOURTEMPLATE/sideboxes/tpl_manufacturer_info.php
change about line 27 from:
Code:
if (zen_not_null($manufacturer_info_sidebox->fields['manufacturers_url']))
$content .= '<div class="manuInfoLink"><a href="http://' . zen_href_link(FILENAME_REDIRECT, 'action=manufacturer&manufacturers_id=' . $manufacturer_info_sidebox->fields['manufacturers_id']) . '" target="_blank">' . BOX_MANUFACTURER_INFO_HOMEPAGE_TEXT . '</a></div>';
to
Code:
if (zen_not_null($manufacturer_info_sidebox->fields['manufacturers_url']))
$content .= '<div class="manuInfoLink"><a href="' . zen_href_link(FILENAME_REDIRECT, 'action=manufacturer&manufacturers_id=' . $manufacturer_info_sidebox->fields['manufacturers_id']) . '" target="_blank">' . BOX_MANUFACTURER_INFO_HOMEPAGE_TEXT . '</a></div>';
Thank you for your reply. I made the code changes but now in the sidebox url link I get http://mydomain.com/manufacturers.com and a 404 error. Looks like the redirect is not working.
Again the link on the Manufacturers All Page works fine.
-
Re: Manufacturers All About Support
This code change has only removed the unneccessary double http://
You posted before that the link was fine, but had a http:// twice in it.
Seems that the link was already wrong before.
A link to your store would help.
-
Re: Manufacturers All About Support
Hello,
Looking at this mod, should be helpful.
What I would like to do if poss, either by way of this mod or another is,
When filtering by manufacturer, have the 'about' text above the product listing.
Any advice on this would be appreciated.
-
Re: Manufacturers All About Support
hello,
is there a demo site which shows the plugin in action?
-
Re: Manufacturers All About Support
Hi,
I have this mod installed on zc155e. Great mod, thank you!!!
Here is my ALL listing:
https://002mc.justmedical.biz/index....ufacturers_all
And here is a page with a description:
https://002mc.justmedical.biz/index....rs_about_id=10
Can anybody tell me how I could add that description to the manufacturer's product listing page:
https://002mc.justmedical.biz/index....acturers_id=10
Thanks!
-
Re: Manufacturers All About Support
Feznizzle
Thanks for you feedback, much appreciated.
Good to see it works with 155e
Thanks
-
Re: Manufacturers All About Support
Hello,
I have a problem with my multi-language shop.
I have integrated the manufacturers_about code in the manufacturers page (tpl_index_product_list.php), and everything works fine, but the manufacturer description text is always english. I've tried a lot, but I can't find I a solution to query the language from the database. Webchill's language fixes are done.
Here is my code in the tpl_index_product_list.php:
PHP Code:
<div class="centerColumn" id="indexProductList">
<h1 id="productListHeading"><?php echo $breadcrumb->last(); ?></h1>
<?php
if (isset($_GET['manufacturers_id']) && $_GET['manufacturers_id'] > 0) {
$chk_manufacturers_image_query = "select m.manufacturers_image, m.manufacturers_name, m.manufacturers_id
from " . TABLE_MANUFACTURERS . " m
where m.manufacturers_id = " . $_GET['manufacturers_id'];
$chk_manufacturers_image = $db->Execute($chk_manufacturers_image_query);
echo '<div class="floatLeft">' . zen_image(DIR_WS_IMAGES . $chk_manufacturers_image->fields['manufacturers_image']) . '</h1></div>';
}
?>
<?php
if (isset($_GET['manufacturers_id']) && $_GET['manufacturers_id'] > 0) {
$chk_manufacturers_about_query = "select mi.manufacturers_about, mi.languages_id
from " . TABLE_MANUFACTURERS_INFO . " mi
where mi.manufacturers_id = " . $_GET['manufacturers_id'];
$chk_manufacturers_about = $db->Execute($chk_manufacturers_about_query);
echo '<div class="text">' . $chk_manufacturers_about->fields['manufacturers_about'] . '</div>';
}
?>
Can anyone please help me on this?
Thank you
Tari