Wine Jobs > $targetCity"; echo "

"; echo $targetCity; ?>

"; echo "\r\n"; while($row = mysql_fetch_array($query3, MYSQL_ASSOC)){ $jobID = $row['job_ID']; $datePosted = substr( $row['datePosted'], 0, 10 ); $categoryID = $row['category']; $siteURL = $row['siteURL']; $description = stripslashes($row['description']); $image = $row['LI_ID']; $title = stripslashes($row['title']); $status = $row['status']; $vintage = $row['vintage']; $phoneNumber = $row['phoneNumber']; $jobLink = $row['jobLink']; $apply = $row['apply']; $companyID = $row['companyID']; $city = $row['city']; $state = $row['state']; if (strlen($description) > 314) { $description = substr( $description, 0, 310 ); $description = $description." ..."; } $i = $i+1; if ($i%2==0) $bgColor = "#FFFFFF"; else $bgColor = "#FFFFCC"; $origLink = $row['origLink']; $getCompanyName = mysql_query("SELECT companyName FROM wine_company WHERE companyID = $companyID", $odbc) or die (mysql_error()); while($row = mysql_fetch_array($getCompanyName, MYSQL_ASSOC)){ $companyName = $row['companyName']; } $getCategoryName = mysql_query("SELECT categoryName FROM jobs_category WHERE categoryID = $categoryID", $odbc) or die (mysql_error()); while($row = mysql_fetch_array($getCategoryName, MYSQL_ASSOC)){ $categoryName = $row['categoryName']; } $tempURL = ""; if (!$locationName) $locationName = "not specified"; echo " \r\n"; echo " \r\n"; echo " \r\n"; } ?>
Job TitleCategoryCompanyDate Posted
".$tempURL."$title$categoryName$companyName$datePosted
$description ".$tempURL."more info"; if (strlen($origLink) > 0) { $linkHost = parse_url($origLink); $linkHost = $linkHost['host']; echo "
From $linkHost"; } echo "

"; else echo ""; ?>

Featured Wines