MySQL Problem

[bgroup99]

Hi,

I recently updated my /includes/functions/functions_prices.php file to enable MAP pricing. I replaced:
return $final_display_price . $free_tag . $call_tag; (around line 296) to:

//Map Pricing by SlickRicky Design : http://www.slickricky.com
$database = mysql_connect('<DATABASE HOST>', '<DATABASE NAME>', '<DATABASE PASSWORD>')
or die('Could not connect: ' . mysql_error());
mysql_select_db('<DATABASE NAME>') or die('Could not select database');
$query = sprintf("SELECT map_enabled FROM ".TABLE_PRODUCTS." where products_id = '" . $products_id . "'" . " limit 1");
$result = mysql_query($query);
$is_map_enabled = mysql_result($result, 0);

if ($is_map_enabled == 1){
return '<span class="map_pricing">'.MAP_PRICE_STORE_FRONT_TEXT.'</span>';
} else {
return $final_display_price . $free_tag . $call_tag;
}
//End Edit SlickRicky Design : http://www.slickricky.com

I entered mysql.shop.thebricktongroup.com as my db host and I entered the name of my db "store" and the correct password.

Now when I try to access my site I get the following error:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host '<mysql.shop.thebricktongroup.com>' (1) in /home/.frowsy/bgroup01/shop.thebricktongroup.com/includes/functions/functions_prices.php on line 282
Could not connect:

Any ideas would be greatly appreciated.

Nate

[barco57]

Does that db host name match what is in your config files?

all of mine have localhost listed there.

[bgroup99]

Which config files are you referring to? i.e. where are they located.

I tired changing db name in the function_prices.php file to localhost, but to no avail.

Thanks though,

Nate

[barco57]

admin/includes/configure.php
includes/configure.php

These are the config files that were set up when you installed the cart. If your cart worked before then the files have the correct path to the Database list in them

[bgroup99]

I figured it out. I had some <>'s where I shouldn't have had them in the function_prices.php file.

Thanks,

Nate