Putting Sale text in header from Sales manager

Okay, so I have my store running. I am running a sale right now, but I want a snippet of code put into my header.php that will:

1. Parse the sales list in the database (that are defined in the Sales Manager).
2. Gets sale information for the sale with the lowest ZOrder.
3. Defines HEADER_SALES_TEXT with the following "Take advantage of our " + Sales Name + " Sale and save " + Sale Amount Off + " through " + End of Sale Date + "!"

This would allow my sales in my Sales manager to automatically update the header as sales are created and deleted.

Anyone have an idea of how to do this?

In your template's tpl_header.php there is a section of code similar to this:```

  <div id="tagline"><?php echo HEADER_SALES_TEXT;?></div>

You could change it to something like this:```
<?php
$saleDetails = $db->Execute("select * from " . TABLE_SALEMAKER_SALES . " where sale_status=1 order by sale_date_end asc, sale_id asc");
if ($saleDetails->RecordCount()) {
  $saleTitle = $saleDetails->fields['sale_name'];
  $saleAmount = number_format($saleDetails->fields['sale_deduction_value'], 2); // might have to adjust depending on sale_deduction_type setting
  $saleExpiry = $saleDetails->fields['sale_date_end']; // might have to adjust if you forget to set an expiry date
?>
      <div id="tagline">Take advantage of our <?php echo $saleTitle;?> Sale and save <?php echo $saleAmount;?> through <?php echo $saleExpiry;?>!</div>
<?php
              }
?>

Okay, I figured out what should be inserted:

<?php
$saleDetails = $db->Execute("select * from " . TABLE_SALEMAKER_SALES . " where sale_status=1 order by sale_date_end asc, sale_id asc");
if ($saleDetails->RecordCount()) {
$saleTitle = $saleDetails->fields['sale_name'];
$saleAmount = number_format($saleDetails->fields['sale_deduction_value'], 2); // might have to adjust depending on sale_deduction_type setting
$saleExpiry = $saleDetails->fields['sale_date_end']; // might have to adjust if you forget to set an expiry date
?>
      <div id="tagline">Take advantage of our <?php echo $saleTitle;?> Sale and save <?php 
if ($saleDetails->fields['sale_deduction_type'] == 2) echo '$';
echo round($saleAmount); 
if ($saleDetails->fields['sale_deduction_type'] == 1) echo '%';
?> through <?php echo $saleExpiry;?>!</div>