|
|
|
|
|
add($details[name], $details[detail]);
} // end while
$sql = "select price, thumbimage, isnull(price, 0) - isnull(rebatepostpaid3yearagreement, 0) - isnull(discountwith3yearagreement, 0) as pricewithagreement from unipageone.item where id = $phone1";
$result = mssql_query($sql) or die ("can't search.");
$details = mssql_fetch_array($result);
$dict1->add("Thumbimage", "/".$details[thumbimage]);
$dict1->add("Retail Price", $details[price]);
$dict1->add("Price w/ 3-Year Agreement", $details[pricewithagreement]);
$CategorySql = $CategorySql . " or itfd.itemid = $phone1";
}
if ($phone2 != '') {
$sql = "select itf.name, itfd.detail from unipageone.itemfeaturedetail itfd left join unipageone.itemfeature itf on itf.id = itfd.itemfeatureid where itfd.itemid = $phone2";
$result = mssql_query($sql) or die ("can't search.");
while ($details=mssql_fetch_array($result))
{
$dict2->add($details[name], $details[detail]);
} // end while
$sql = "select price, thumbimage, isnull(price, 0) - isnull(rebatepostpaid3yearagreement, 0) - isnull(discountwith3yearagreement, 0) as pricewithagreement from unipageone.item where id = $phone2";
$result = mssql_query($sql) or die ("can't search.");
$details = mssql_fetch_array($result);
$dict2->add("Thumbimage", "/".$details[thumbimage]);
$dict2->add("Retail Price", $details[price]);
$dict2->add("Price w/ 3-Year Agreement", $details[pricewithagreement]);
$CategorySql = $CategorySql . " or itfd.itemid = $phone2";
}
if ($phone3 != '') {
$sql = "select itf.name, itfd.detail from unipageone.itemfeaturedetail itfd left join unipageone.itemfeature itf on itf.id = itfd.itemfeatureid where itfd.itemid = $phone3";
$result = mssql_query($sql) or die ("can't search.");
while ($details=mssql_fetch_array($result))
{
$dict3->add($details[name], $details[detail]);
} // end while
$sql = "select price, thumbimage, isnull(price, 0) - isnull(rebatepostpaid3yearagreement, 0) - isnull(discountwith3yearagreement, 0) as pricewithagreement from unipageone.item where id = $phone3";
$result = mssql_query($sql) or die ("can't search.");
$details = mssql_fetch_array($result);
$dict3->add("Thumbimage", "/".$details[thumbimage]);
$dict3->add("Retail Price", $details[price]);
$dict3->add("Price w/ 3-Year Agreement", $details[pricewithagreement]);
$CategorySql = $CategorySql . " or itfd.itemid = $phone3";
}
?>