0

I have the following code:

$rebate_query = tep_db_query("select * from " . TABLE_REBATES . " where product_id = " . (int)$HTTP_GET_VARS['products_id']);
    $rebate_information = tep_db_fetch_array($rebate_query);

This should return only 1 row of data

I have this code - "

$rebate = $rebate_information['rebate_amount'];

"
for extracting the rebate amount. For the life of me I cannot
understand why this isn't working. It doesn't error out, but nothing is returned, and I know that the value exists.

I would very much appreciate any help you can give. Thanks.

2
Contributors
5
Replies
6
Views
12 Years
Discussion Span
Last Post by Gary King
0

Use this code instead:

$rebate = mysql_fetch_array($rebate_information['rebate_amount']); 
$rebate = $rebate[0];

And now, $rebate is set :)

Let me know if it didn't work; my PHP is a bit on the rough side during March Break :p

0

Use this code instead:

$rebate = mysql_fetch_array($rebate_information['rebate_amount']); 
$rebate = $rebate[0];

And now, $rebate is set :)

Let me know if it didn't work; my PHP is a bit on the rough side during March Break :p

Hi Gary. Thanks for the response. I am getting the following error when I try your suggestion:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.

I tried using the oscommerce fetch array function in its place, and that didn't work either. I am stumped on this for some reason. Logically, it doesn't make much sense to me yet.

If you could take another look I'd appreciate it.

Thanks again.

0

Thanks for your help. I had a different problem which was causing
my grief - got everything working now......

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.