chrometweaks.org

What is NASCAR Nation's favorite iPage.com Danica Patrick commercial?

Click Here To View All Answers...


Got a question... What is NASCAR Nation's favorite iPage.com Danica Patrick commercial? Thanks in advance for any answer. 2nd question I got is.. I thought it’s going to be easy, but I got stacked..

I would like to show the manufacturers name on the product_info page right below the Name and Model. I’ve been messing with the code for some time but cannot figure this out..

If someone could help me out on this I would be very grateful.

..

Thanks.

Andrew..

Comments (108)

That's a good question. I'm not sure what is the answer to that question. I'll do some research and get back to you if I find an useful answer. You should email the people at iPage as they probably could give you an answer..

Comment #1

Hi Gotmallz, thanks for reply..

Here is the part of the code where I made the changes. Because I dont use Product Model I just changed it to Manufacturers Name, but I get this error mesage.

1054 - Unknown column 'p.manufacturers_name' in 'field list'.

Select p.products_id, pd.products_name, pd.products_description, p.manufacturers_name, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '28' and pd.products_id = p.products_id and pd.language_id = '1'.

Here is the code (I highlitet the changes I made).

<?php.

} else {.

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description,.

P.manufacturers_name.

, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

$product_info = tep_db_fetch_array($product_info_query);.

Tep_db_query("update "TABLE_PRODUCTS_DESCRIPTION" set products_viewed = products_viewed+1 where products_id = '"(int)$HTTP_GET_VARS['products_id']"' and language_id = '"(int)$languages_id"'");.

If ($new_price = tep_get_products_special_price($product_info['products_id'])) {.

$products_price = '<s>'$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))'</s> <span class="productSpecialPrice">'$currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))'</span>';.

} else {.

$products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));.

}.

If (tep_not_null($product_info[.

'manufacturers_name'.

])) {.

$products_name = $product_info['products_name']'<br><span class="smallText">['$product_info[.

'manufacturers_name'.

]']</span>';.

} else {.

$products_name = $product_info['products_name'];.

}.

?>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="productHeading" valign="top"><?php echo $products_name; ?></td>.

<td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

</tr>.

<tr>.

<td class="main">.

<?php.

I hope we can sort this out it's been bothering me for couple of days..

Thanks again.

Andrew..

Comment #2

OK heres almost what it looks like number one it's not running the correct query to the DB or number two the DB is not there.....

Im still reviewing the code but I dont see anything that slaps me int he face though yet......

Comment #3

AAAAhhhhhhhhh I just saw soemthing.

You changed model to manufacturer this is running a dif query pattern I think Im still reviewing this though..

Comment #4

Hi Gotmallz.

When I do the same thing but put manufacturers_id in place of manufacturers_name then it works fine it shows the id in the product info page..

Thanks again for looking into it for me..

Andrew..

Comment #5

Exactly, I just changed product_model to manufacturers_name, because I dont use the model option.

This post has been edited by.

Aozlanski.

: 07 March 2004, 05:52..

Comment #6

Did you also change this in the DB as well..

Comment #7

No I didn’t touch the DB. I figured that since the manufacturers name is already in the DB it would be pulled instead of the model..

Comment #8

Gotmallz must have given up. Anyone else can look at it?.

Thanks.

Andrew..

Comment #9

This is how I did, i'm not sure that this is the best solution but it works :.

Put in product_info.php wherether you want :.

<?.

$id_manu = $product_info['manufacturers_id'];.

$manufacturers_query = tep_db_query("select manufacturers_name, manufacturers_id, manufacturers_image from manufacturers where manufacturers_id = $id_manu");.

$manufacturers = tep_db_fetch_array($manufacturers_query);.

$manufacturers_links_query = tep_db_query("select manufacturers_url from manufacturers_info where manufacturers_id = $id_manu");.

$manufacturers_links = tep_db_fetch_array($manufacturers_links_query);.

Echo '<a href="'$manufacturers_links['manufacturers_url']'" target="_blank">';.

Echo stripslashes($manufacturers['manufacturers_name']);.

Echo '<br>';.

Echo tep_image(DIR_WS_IMAGES$manufacturers['manufacturers_image']);.

Echo '</a>';.

?>.

It's work super fine for me..

Enjoy it..

F...

Comment #10

I thought it’s going to be easy, but I got stacked..

I would like to show the manufacturers name on the product_info page right below the Name and Model. I’ve been messing with the code for some time but cannot figure this out..

If someone could help me out on this I would be very grateful.

..

Thanks.

Andrew..

Comment #11

U have to place a query in the code luine which will query the DB by the products number and request the manufacturer name. I know this sounds easy but as I have learned nothing worth doing right is easy in coding....

Place a small post of your code here and Ill take a look see for you...

Comment #12


This question was taken from a support group/message board and re-posted here so others can learn from it.