I will pay £20 for the 1st to help - and it works. PHP coding needed

I have bought he add block mod from deano,  I would like to point out this is a great mod.  Anyway what I am looking to do is create a block to display just a telephone number.  Therefore what is the php code for echo $anynumber where the $anynumber is a custom field and to pull the listing headline.

The reason I need to pull this information is that I will be using this information to work with a sms script I have bought where the user can have this infomration text to thier phone for free from a form I will be creating within this block in html.

The first person to provide this working solution will receive £20.00 via PayPal

Many thanks

Gareth

If you have a profile field called PhoneNumber, the following code will display the value in a PHP block. I tested this on the profile page, I can't guarantee it will work on other pages. Let me know if it works for you.

$iProfileID = getID( $_GET['ID'] );

$oDb = new BxDolDb();

$sSQLQuery = "SELECT PhoneNumber FROM `Profiles` WHERE `ID` = $iProfileID;";

$sPhoneNumber = $oDb->getColumn($sSQLQuery);

echo $sPhoneNumber[0];

Hi Marvin

Many thanks, if you can pm me your paypal email address, I will forward your £20 tomorrow.

Once again thank you.

Gareth