Need to add an image in this string helpplease

Shorty_Phil

Hey guys ok its probably an easy fix but all methods i try give ,me a t string error..

this is the code im using and works as is

$db = JFactory::getDBO();
     $db->setQuery("SELECT custom_value FROM #__virtuemart_product_customfields WHERE virtuemart_product_id=".$product->virtuemart_product_id." and virtuemart_custom_id=29 ;");  

     $db->query();
     $result = $db->loadResult();
	 echo "<div class=\"YourClass1\">Name:  ".$result."</div>";

The above snippet is working perfect for me.. What i want to fo is replace the part "Name: " with an image and i am struggling.. can some one help me please.

Thank you

Shorty_Phil

Also if possible I would like to be able to give the image its own css class..

Shorty_Phil

Not sure if its relative but this is being used within virtuemart 2 (joomla 2.5) to show custom fields on products shown on category pages.

NogDog

Is the image URL hard-coded or dynamic? If hard-coded, it would just be something like:

echo "<div class=\"YourClass1\"><img class='whatever_you_want' src='http://example.com/images/whatever.jpg' /></div>";

Shorty_Phil

OK so now working and just need to dreate the css side and name it but showing an image 🙂

Thank You !!!!!!

 $db = JFactory::getDBO();
 //please do check in php myadmin how your database table is called and replace it instead of "VM2_virtuemart_product_customfields" replace the "6" with your ID of Custom field you want to output
 $db->setQuery("SELECT custom_value FROM #__virtuemart_product_customfields WHERE virtuemart_product_id=".$product->virtuemart_product_id." and virtuemart_custom_id=29 ;");  
 $db->query();
 $result = $db->loadResult();
 echo "<div class=\"YourClass1\"><img class='whatever_you_want' src='http://example.com/images/whatever.jpg' />" .$result."</div>";

Shorty_Phil

How would i re write this below so the image and result are on the same line but can be set with padding and margin different to one and another..

At thew moment if i change css on either YourClass2 or YourImageClass it will change both image and text and will not do one or the other

          <?php 
         //MY EDIT STARTS HERE

//make a database connection and find the field record that contains the customfield string
$db = JFactory::getDBO();
//please do check in php myadmin how your database table is called and replace it instead of "VM2_virtuemart_product_customfields" replace the "6" with your ID of Custom field you want to output
$db->setQuery("SELECT custom_value FROM #__virtuemart_product_customfields WHERE virtuemart_product_id=".$product->virtuemart_product_id." and virtuemart_custom_id=30 ;");

$db->query();
$result = $db->loadResult();
echo "<div class=\"YourClass2\"><img class=\"YourImageClass2\" src='/images/style1/search_bg.png' />" .$result."</div>";
?>

Shorty_Phil

<?php 
$db = JFactory::getDBO();
//please do check in php myadmin how your database table is called and replace it instead of "VM2_virtuemart_product_customfields" replace the "6" with your ID of Custom field you want to output
$db->setQuery("SELECT custom_value FROM #__virtuemart_product_customfields WHERE virtuemart_product_id=".$product->virtuemart_product_id." and virtuemart_custom_id=30 ;"); 
$db->query();
$result = $db->loadResult();
echo "<div class=\"YourClass2\"><img class=\"YourImageClass2\" src='/images/style1/search_bg.png' />" .$result."</div>";
?>