Sure thing.
Below is my full query. This is for a detail page on a real estate website. So if boolActivate=0 then the property should not display anything.
$strQuery = sprintf( "SELECT p.*, a.strAreaName FROM tblProperties p LEFT JOIN tblAreas a ON p.intAreaID = a.intID WHERE p.intID = %d AND p.boolActivate = 1", intval($intPropertyID));
$queryGetProperty = $objDatabase->query($strQuery);
if ($objDatabase->num_rows($queryGetProperty) > 0) {
$arrRow = $objDatabase->fetch_assoc($queryGetProperty);
extract($arrRow);
if (strlen($dtDateAvailable) > 0) {
$dtDateAvailable = date("m/d/y", strtotime($dtDateAvailable));
}
if (strlen($dtDateAvailableSummer) > 0) {
$dtDateAvailable = date("m/d/y", strtotime($dtDateAvailableSummer));
}
if (strlen($dtDateAvailableWinter) > 0) {
$dtDateAvailable = date("m/d/y", strtotime($dtDateAvailableWinter));
}
}
$objDatabase->free_result($queryGetProperty);
$strQuery = sprintf( "SELECT * FROM tblPropertiesPhotos WHERE intPropertyID = %d", intval($intPropertyID));
$queryGetPhotos = $objDatabase->query($strQuery);
Below is a sample echo on the page for part of the content.
<?php
if (($dblPriceYearly > 0) && (strlen($dtDateAvailable) > 0)) {
echo date("m/d/y", strtotime($dtDateAvailable)) . " (Y) ";
}
if (($dblPriceSummer > 0) && (strlen($dtDateAvailableSummer) > 0)) {
echo date("m/d/y", strtotime($dtDateAvailableSummer)) . " (S) ";
}
if (($dblPriceWinter > 0) && (strlen($dtDateAvailableWinter) > 0)) {
echo date("m/d/y", strtotime($dtDateAvailableWinter)) . " (W)";
}
?>
What i'm getting is a detail page with all the relaivant info. I am looking for it to error out and not display any info just as it would if you went to the page and put in an incorrect ?=ID
