TOPIC: Affiliate Script

Hi,

Trying to use this with an affiliate script and need to populate a hidden image tag or a PHP script with information from the database to write back to the affiliate programme.

The hidden image tag ending looks like:

?amount=THE AMOUNT GOES HERE&trans_id=CONFIRMATION GOES HERE" width="1" height="1">

How to I get the script to pull the required field from the database or record without the currency sign, so for example just 10.00

Hope someone can help.

David