Extracting Results from Query

I have the following code:

[php]$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);[/php]

This should return only 1 row of data

I have this code - " [php]$rebate = $rebate_information['rebate_amount'];[/php] "
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.

Ajaxxx

Newbie Poster

4 posts since Mar 2005

Reputation Points: 10

Solved Threads: 0

7 Years Ago

0

I edited code for easier reading.

Gary King

PHP/vBulletin Guru

Team Colleague

417 posts since Nov 2003

Reputation Points: 53

Solved Threads: 5

7 Years Ago

0

Use this code instead: [php] $rebate = mysql_fetch_array($rebate_information['rebate_amount']);
$rebate = $rebate[0];[/php]

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

Gary King

PHP/vBulletin Guru

Team Colleague

417 posts since Nov 2003

Reputation Points: 53

Solved Threads: 5

7 Years Ago

0

Use this code instead: [php] $rebate = mysql_fetch_array($rebate_information['rebate_amount']); $rebate = $rebate[0];[/php]

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.

Ajaxxx

Newbie Poster

4 posts since Mar 2005

Reputation Points: 10

Solved Threads: 0

7 Years Ago

0

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

Ajaxxx

Newbie Poster