echo $fullName ?> PICKS PAGE
echo $longTitle?>
echo $longDesc?>
|
|
$sql = "SELECT categoryName,listingName, pickID, listingID,categoryID FROM $table_picksel where pickID = '$pickID' ORDER by categoryID,listingName";
$result = @mysql_query($sql,$connection) or die("Couldn't execute $sql query.");
$previousCatID = 0;
$newcat = '0';
while ($row = mysql_fetch_array($result)){
$categoryID = $row['categoryID'];
$categoryName = $row['categoryName'];
$listingID = $row['listingID'];
if ($previousCatID != $categoryID){
$newcat = '1';?> }
$sql = "SELECT state,zip,email,url,name,address1, address2, longDesc,town,phone,phone2 FROM $table_lis WHERE listingID = '$listingID'";
$listresult = @mysql_query($sql,$connection) or die("Couldn't execute $sql query.");
$rowlis = mysql_fetch_array($listresult);
$address = $rowlis['address1'];
$listingName = $rowlis['name'];
$phone = $rowlis['phone'];
$phone2 = $rowlis['phone2'];
$zip = $rowlis['zip'];
$state = $rowlis['state'];
$longDesc = $rowlis['longDesc'];
$url = fixurl($rowlis['url']);
$email = $rowlis['email'];
$town = $rowlis['town'];
if ($town != ""){
$town = $town . " -";
}
if ($url != "http://"){
$listingName = "". $listingName . " ";
}
if ($newcat == '1'){?>
echo strtoupper($categoryName) ?> |
}?>
echo $listingName ?> - echo $address ?> echo $town ?> echo $phone ?> echo $phone2 ?>
echo $longDesc ?> Add to my picks! |
}?>
|
|
|
|
|
|
|
if ($sb3image != ""){?>
|
|
}?>
|
if ($sb4image != ""){?>
|
|
}?>
if ($sb5image != ""){?>
|
|
|
}?>
if ($sb6image != ""){?>
|
|
}?>
|
|