Display the result of a query in postbit

[Bastien]

Hi all,

I'm wanting to display in the postbit, the result of a query but that doesn't work and I don't understand why.

So, this is my table fournisseurs : SC1
Here is where I want to display its phone number (alt of the img) : SC2

This is the hook I added for showpost_start :

PHP Code:

$fournisseur = $vbulletin->db->query_first("
            SELECT telephone
            FROM devis_fournisseurs
WHERE userid=$post[userid]  
");    

$telephone="$fournisseur[telephone]";

return $telephone; 


And this is the little part that displays the phone picture and should display the number, but it doesn't

<vb:if condition="$post[usergroupid]==10 || $post[usergroupid]==11">
<img src="images/smilies/telephone.png" alt="test {vb:raw telephone}"></vb:if>

Could someone give me some help ?
Thank you:up: