octal integrers? all eights (8) digits turn into zeroes (0)???

TheFinnisher

Hello,
I'm new to PHPBuilder. In the past I have found many good threads by searching google.🙂

Now I have run into a really strange problem that I can't seem to find anything about...

I hope someone here will be able to give me a hand.

Here's the problem:

I have a products price query that seems to bring the proper product prices. However if the price is saved in the data base as $188.00 the query and php returns 100.00. If I have a product with the price of $208.00 I'nm getting a return of $200.00.

If I change the prices in the database and echange all the 8 digits such as $199.00 the price is dissplayed properly.

Why is this occuring???

I've read something about octal integrers but what does not make sense to me is that the digit nine (9) seems to work...while valid octal intergrers run from 1-7.

Have I missed something else? This is my PHP query:

$family_sql = "select p.products_id, p.products_model, p.products_image, p.products_tax_class_id, pd.products_name, s.specials_new_products_price, s.status, p.products_price, p.products_family from ". TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id !=" . (int)$HTTP_GET_VARS['products_id'] . " and p.products_id = pd.products_id and p.products_family = '" . $thisquery['products_family'] . "' and p.products_status = '1' and pd.language_id = '" . (int)$languages_id . "'"; 
$listing = tep_db_query($family_sql);

//*separate prices
  $customer_group_query = tep_db_query("select customers_group_id, customers_group_name from " . TABLE_CUSTOMERS . " where customers_id =  '" . $customer_id . "'");
  $customer_group = tep_db_fetch_array($customer_group_query);
  $customer_group_name = $customer_group['customers_group_name'];
  $customer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . $listing['products_id'] . "' and customers_group_id =  '" . $customer_group['customers_group_id'] . "'");


  if ( $customer_group['customers_group_id'] != 0) {
   if ($customer_group_price = tep_db_fetch_array($customer_group_price_query)) {
      $products_price_orig = $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id']));
  $products_price_discount = $currencies->display_price($customer_group_price['customers_group_price'], tep_get_tax_rate($listing['products_tax_class_id']));

  $products_price_saving = $currencies->display_price($listing['products_price'] - $customer_group_price['customers_group_price'], tep_get_tax_rate($listing['products_tax_class_id']));
    } else {
        $products_price_orig = $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id']));
      }
  } else {
    $products_price_orig = $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id']));
    }
//EOF separate prices*/

and this is how I dissplay the information:

$lc_text = '&nbsp;<s>' . $products_price_orig . '</s>&nbsp;<span class="productSpecialPrice">' . $customer_group_name . '-team:'. $products_price_discount . '</span>&nbsp;';

How in the world can I solve this issue?
Thank you in advance.

drew010

what data type is the field? it would need to be of a char or varchar type and not numeric since you are trying to save a $ sign into it. that could cause the db program to strip off the $ and perhaps do who knows what to the other data.

TheFinnisher

Hi drew,
Thank you for your reply. At this point I am thankful for any suggestions. My data field is specified as decimal (15,4). The dollar sign ($) is not stored in the database. I think that is what the $currencies function is for. Maybe I need to find this function and see what it does?

I tried changing that field into a varchar but no change occured. I still get that strange behaviour.

What do you think? What else could cause this occurence?

Thank you!

tekky

sounds like something in your class is converting the results some how....

to clarify that I would suggest using phpMyAdmin and pasting in one of the queries you use to see if you do get the rounded #'s from SQL or from your PHP script...

if you get the same results... then possibily something in the DB insert functions of the script... otherwise... well its something else otherwise 😉

TheFinnisher

Hi Karl,
Thank you for that tip. I'm going to give it a try. I have actually never tried to do a query in phpMyAdmin. I gave it a try by pasting in the query in the SQL mode. I just didn't know how to combine the query since the final query seems to utilize the base of two other queries: "$family_sql" and the "$thisquery['products_family']".

I also tried to change the queries so that I removed the class $currencies->display_price BUT STILL GOT THE error of the eights (8) turning into zeroes (0).

I'm going to keep trying and also try figure out how I can test the query directly in phpMyAdmin.

TheFinnisher

hey guys,
I've been working on this problem and tried a bunch of changes.
Eventually I tried to see what would happen if I changed the product price dissplay. I swapped places of the discount price and the original price and to my horror and relief...

THIS IS KINDA EMBARRASSING!

Well, I found out that the product prices for both original (MSRP) and discount were quieried right. It was the <S></S> strikeout that caused the problem! The strikeout appeared to strikeout EXACTLY where the horizontal line of the eights...AND THAT"S WHY IS SAW THE DISCREPANCY!

How embarrassing.:queasy:

Well, at least I figured it out. Funny how I thought it had to do with something such as octal integrers. I spent days worrying about it! ha,ha

Well, at least I was taught a lesson. Sometimes things aren't what they look to be...(and I thought I knew that lessonha,ha)

Anyhow, thank you both for coming up with inventive solutions and help. Maybe someone else stumbles upon this thread sometimes in the future. 🙂

tekky

lol, awesome 😃