200){ $Description2=substr($Description,0,190).""." - "." more info"; } else { $Description2=$Description; } $randdata.="".$winery."\n"; } $query2="SELECT * FROM TJ_EVENT where Publish_Flag='Y' and Event_Start_Date >= curdate() - Interval 1 Day ORDER BY Event_Start_Date ASC LIMIT 7"; $dbresult2 = mysql_query($query2, $dbconnect); $num2 = mysql_num_rows($dbresult2); $eventdata.=" Event Date\n Event\n Region\n State\n \n"; while ($row2 = mysql_fetch_array($dbresult2)) { $Event_ID=str_replace("'","'", $row2["Event_ID"]); $Event_Start_Date=str_replace("'","'", $row2["Event_Start_Date"]); $Event=str_replace("'","'", $row2["Event"]); $Region=str_replace("'","'", $row2["Region"]); $Country=str_replace("'","'", $row2["Country"]); $State=str_replace("'","'", $row2["State"]); $eventdata.=" ".$Event_Start_Date." ".$Event." ".$Region." ".$State." \n"; } $query3="SELECT * FROM TJ_WINEBAR where Publish_Flag='Y' ORDER BY RAND() LIMIT 7"; $dbresult3 = mysql_query($query3, $dbconnect); $num3 = mysql_num_rows($dbresult3); $bardata.=" WineBar\n City\n Region\n State\n \n"; while ($row3 = mysql_fetch_array($dbresult3)) { $WineBar_ID=str_replace("'","'", $row3["WineBar_ID"]); $WineBar=str_replace("'","'", $row3["WineBar"]); $City=str_replace("'","'", $row3["City"]); $Region3=str_replace("'","'", $row3["Region"]); $Country3=str_replace("'","'", $row3["Country"]); $State3=str_replace("'","'", $row3["State"]); $bardata.=" ".$WineBar." ".$City." ".$Region3." ".$State3." \n"; } $query4="Select * from TJ_JOURNAL where obsolete_date is null and Journal_Public_Type in ('Public', 'NotesPublic') ORDER BY RAND() LIMIT 5"; $dbresult4 = mysql_query($query4, $dbconnect); $num4 = mysql_num_rows($dbresult4); $journaldata.=" Recommendation\n Winery\n Wine\n Vintage\n \n"; while ($row4 = mysql_fetch_array($dbresult4)) { $View_Journal_Number=$row4["Journal_Number"]; $View_Recommendation=$row4["Recommendation"]; $View_Wine_Name=$row4["Wine_Name"]; $View_Vintage=$row4["Vintage"]; $View_Winery=$row4["Winery_Name"]; if ($View_Recommendation==1) {$Recommendation_Img="star1.gif";} if ($View_Recommendation==3) {$Recommendation_Img="star2.gif";} if ($View_Recommendation==5) {$Recommendation_Img="star3.gif";} if ($View_Recommendation==7) {$Recommendation_Img="star4.gif";} if ($View_Recommendation==10) {$Recommendation_Img="star5.gif";} $journaldata.=" \"TastingJournals.com\" ".$View_Winery." ".$View_Wine_Name." ".$View_Vintage." \n"; } $rand_image_id=rand(1, 8); if ($rand_image_id==1) {$rand_image="vineyards";} if ($rand_image_id==2) {$rand_image="usa_ca_greenwood_ridge_vineyards";} if ($rand_image_id==3) {$rand_image="tasting_room";} if ($rand_image_id==4) {$rand_image="vineyards2";} if ($rand_image_id==5) {$rand_image="corks";} if ($rand_image_id==6) {$rand_image="usa_ca_lazy_creek_vineyards_c";} if ($rand_image_id==7) {$rand_image="usa_ca_mendocino_roederer_estate_b";} if ($rand_image_id==8) {$rand_image="usa_ca_napa_monticello_grapes_a";} $imagetable="\n"; $imagetable.="\n"; $imagetable.="
\"TastignJournals.com\"
\n"; $featuredwinery="\n"; $featuredwinery.="\n"; $featuredwinery.="
Wineries
\n"; $featuredwinery.=$randdata; $featuredwinery.="
\n"; $events_table="\n"; $events_table.="\n"; $events_table.="
Wine Events
\n"; $events_table.="\n"; $events_table.=$eventdata; $events_table.="
\n"; $bar_table="\n"; $bar_table.="\n"; $bar_table.="
Wine Bars
\n"; $bar_table.="\n"; $bar_table.="
\n"; $bar_table.=$bardata; $bar_table.="
\n"; //$journal_table="\n"; //$journal_table.="\n"; //$journal_table.="
Tasting Journals
\n"; $journal_table.="\n"; $journal_table.=$journaldata; $journal_table.="
\n"; $welcometable="\n"; $welcometable.="\n"; $welcometable.="\n"; $welcometable.="\n"; $welcometable.="
Welcome to TastingJournals.com
A unique tool to Research, Record, and Remember your wine tasting adventures. Whether you enjoy visiting wineries, frequenting restaurants or just sipping wine at home with friends and family, we are here to bring more fulfillment to these times in life.
Come on in and share a glass with us...
\n"; $welcometable.=$journal_table; $privacypolicy="\n"; $privacypolicy.="\n"; $privacypolicy.="
* Tasting Journals.com makes every attempt to ensure that the information on this and every page is current and correct. We always recommend contacting a winery, wine bar or event organizer to ensure that the event has not been changed or cancelled. If you notice that any information is incorrect, please contact us so that we may correct any details to help others.
\n"; $title="TastingJournals.com - Tasting Journals - Research, Record, and Remember your wine tasting adventures"; $contactus="Questions? Contact Us!\n"; ?>

Get the Flash Player to see this player.