Hi Again...
On the same script as I was working on... On this line...
echo "<tr><td>$domain</td><td>$price</td><td>
How would I get the regular price and then next to it the price divided by 50%? I would like to be able to offer discounts some days that would show the regular price, and next to the the new discounted price. I know how to do it by itself, bt I am not sure how to do it when it is all on the same line.
Any help would be appreciated...
Thanks,
Doug
-------------script----------
<?
mysql_connect("localhost","xxxxxxxx","xxxxxxx");
mysql_select_db("thedatabase");
$query = "SELECT * FROM dd_domains WHERE price >= 99 ORDER BY name";
$result = mysql_query($query);
echo "<html><body bgcolor=\"#FFFFFF\"><table border=\"0\" align=\"center\" width=\"600\" cellspacing=\"0\" cellpadding=\"2\"><tr><td><b>Domain</b></td><td><b>Price</b></td></tr>";
while($row = mysql_fetch_array($result))
{
$price = $row['priceb'];
$domain = $row['name'];
echo "<tr><td>$domain</td><td>$price</td><td><a href=\"mailto:$domain@mywebsite.com?subject=$domain\">Contact Us</a></td></tr>";
}
echo "</table></body></html>";
?>
!
Bookmarks