Hi,

I need some advise in splitting this echo into a table with 1 row and 2 columns.

The first column needs to be the £{$row['Price_ExVat']} + vat part and the second the link to the buy button.

Hope this makes sense!!

PHP Code:

<?php


//--------------'PRICE BEFORE VAT CODE'---------------------
$strProd_REF = "591";
$strCar_ID = "def";
$sqlSelect = "SELECT Prod_ID, Price_ExVat FROM products WHERE Prod_REF = '" . $strProd_REF . "' AND Car_ID = '" . $strCar_ID . "'
";

// assign the basic sqlquery
$sqlquery = $sqlSelect;

//get the result set
$result = mysql_query($sqlquery);
while ($row = mysql_fetch_assoc($result))
{
    echo "£{$row['Price_ExVat']} + vat <a href=\"basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $row["Prod_ID"] . "\"><img src=\"images/addtobasket.jpg\" width=\"55\" height=\"28\" border=\"0\"></a>";
    
//end make while

    }
    $row = "";
    mysql_free_result($result); 

//--------------'END PRICE CODE'---------------------

?>

PHP Code:

<?php
echo ('<table width="xx">');
echo ('<tr>');
echo ('<td>');
// cell data column1 goes here
echo ('</td>');
echo ('<td>');
// cell data column2 goes here
echo ('</td>');
echo ('</tr>');
echo ('</table>');
?>

PHP Code:

<?php 


//--------------'PRICE BEFORE VAT CODE'--------------------- 
$strProd_REF = "591"; 
$strCar_ID = "def"; 
$sqlSelect = "SELECT Prod_ID, Price_ExVat FROM products WHERE Prod_REF = '" . $strProd_REF . "' AND Car_ID = '" . $strCar_ID . "' 
"; 

// assign the basic sqlquery 
$sqlquery = $sqlSelect; 

//get the result set 
$result = mysql_query($sqlquery);
?>
<table>
<?php while ($row = mysql_fetch_assoc($result)) : ?>
     <tr>
          <td>
               <?php echo "£{$row['Price_ExVat']} + vat" ?>
          </td>
          <td>
               <?php echo "<a href=\"basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $row["Prod_ID"] . "\"><img src=\"http://www.webmaster-talk.com/images/addtobasket.jpg\" width=\"55\" height=\"28\" border=\"0\"></a>"; ?>
          </td>
     </tr>
<?php endwhile; ?>
</table>
<?php
$row = ""; 
mysql_free_result($result);  

//--------------'END PRICE CODE'--------------------- 

?>

Thanks Guys,

Got it working great now!

Another question!

I need to display the price including the vat (tax) at 17.5% , as the database only has the before vat price stored, can I adjust this line to automatically add it?

PHP Code:

<?php echo "£{$row['Price_ExVat']}" ?>

Just to clarify, you need to apply a 17.5% tax to the number pulled from the database?

PHP Code:

<?php echo '£' . round($row['Price_ExVat'] * 1.175, 2) ?>

Thanks Mike,

That is exactly what I am trying to do.

Some of our products need to be displayed before VAT and some including.

This code now saves me HOURS of updating pages!

Using a constant for the VAT multiplier can also be advantageous.

Ahh, now that IS a good point Chris...

If (when) the government decide to play with the vat rate again, it would mean changing the code on ALL the buttons...!