referrer = $url\n";
if ( ereg("(http://|http://www\.)([^\/]+)\/(.*)",$url,$regs) ) {
#echo "site = $regs[2]
";
$referrer = $regs[2];
} else {
$referrer = "default";
}
$db_object = mysql_pconnect()
or die("Could not connect to database.\n");
mysql_select_db("pricedata")
or die("Could not select database.\n");
$query = setQuery($referrer,$product,$site);
#echo("query = \n $query\n");
$result = mysql_query($query) or die("Unable to execute query.\n");
if ( mysql_num_rows($result) == 0 ) {
#echo "Found zero rows using $referrer
";
$query = setQuery("default",$product,$site);
# echo("query = \n $query\n");
$result = mysql_query($query) or die("Unable to execute query.\n");
}
while ( $row = mysql_fetch_assoc($result) ) {
if ( $row["dosage"] == (int)$row["dosage"] ) { $row["dosage"] = (int)$row["dosage"]; }
$units = $row["dosage_units"];
if ( $last_dosage != $row["dosage"] ) {
echo("
| Company |
Dosage
($units) |
Quantity |
Price |
Doctors Consultation |
US Shipping |
Ship UK & Int? |
Total Cost |
Click to Order | ");
echo("
\n");
$last_dosage = $row["dosage"];
}
if ( $last_quantity != $row["quantity"] ) {
echo("
|
dosage: " .
$row["dosage"] . " " . $row["dosage_units"] . " quantity: " . $row["quantity"] .
" |
\n");
$last_quantity = $row["quantity"];
}
if ( $row["consultation"] == "0" || $row["consultation"] == "$0" ) { $row["consultation"] = "Free"; }
if ( $row["ship_cost"] == "0" || $row["ship_cost"] == "$0") { $row["ship_cost"] = "Free"; }
if ( $row["price"] == "0" || $row["price"] == "$0" ) { $row["price"] = "Free"; }
echo("\n");
echo("| "
. $row["vendor"] . " | ");
echo("" . $row["dosage"] . " | ");
echo("" . $row["quantity"] . " | ");
echo("" . $row["price"] . " | ");
echo("" . $row["consultation"] . " | ");
echo("" . $row["ship_cost"] . " | ");
echo("" . $row["ship_int"] . " | ");
echo("\$" . $row["total_cost"] . " | ");
echo(" Order | ");
echo("
\n");
}
mysql_close($db_object);
} # end function showTable()
} # if not defined
?>