0) and (strlen($PATH_INFO[1])>0)) { $alpha_code=substr($PATH_INFO[1],0,1); $alpha="and substring(event,1,1)='".substr($PATH_INFO[1],0,1)."' "; //echo $alpha; $PATH_INFO[1]=substr($PATH_INFO[1],1); //echo $PATH_INFO[1]; } if (!(strlen($PATH_INFO[1])>0)) { $Record=0; //echo "Record set to Zero"; } else { $Record=$PATH_INFO[1]; } $RecordMax=$Record+25; $query_Count="SELECT count(*) as WINERY_COUNT FROM TJ_EVENT where Publish_Flag='Y' ".$alpha." order by Event"; $dbresult_Count = mysql_query($query_Count, $dbconnect); $num_Count = mysql_num_rows($dbresult_Count); while ($row = mysql_fetch_array($dbresult_Count)) { $Winery_Count=$row["WINERY_COUNT"]; } $query="SELECT * FROM TJ_EVENT where Publish_Flag='Y' ".$alpha." order by Event limit ".$Record.", 25"; //echo $query; $dbresult = mysql_query($query, $dbconnect); $num = mysql_num_rows($dbresult); $table.="\n"; $table.="

A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z

All Events

\n"; $table.="\n"; $table.="\n"; $table.="

Profiled Wine Events

"; $table.="\n"; $table.="\n \n \n \n \n \n \n"; $border=1; while ($row = mysql_fetch_array($dbresult)) { //Find and replace ' for strings $Event_ID=str_replace("'","'", $row["Event_ID"]); $Event=str_replace("'","'", $row["Event"]); $Event_Type=str_replace("'","'", $row["Event_Type"]); $Focus=str_replace("'","'", $row["Focus"]); $Action_Word=str_replace("'","'", $row["Action_Word"]); $Website=str_replace("'","'", $row["Website"]); $Description=str_replace("'","'", $row["Description"]); $Region=str_replace("'","'", $row["Region"]); $Appellation=str_replace("'","'", $row["Appellation"]); $GPS_Coordinates=str_replace("'","'", $row["GPS_Coordinates"]); $Date_Established=str_replace("'","'", $row["Date_Established"]); $Propreitor=str_replace("'","'", $row["Propreitor"]); $Event_Organizer=str_replace("'","'", $row["Event_Organizer"]); $Highlighted_Participants=str_replace("'","'", $row["Highlighted_Participants"]); $Seasons=str_replace("'","'", $row["Seasons"]); $Frequency=str_replace("'","'", $row["Frequency"]); $Days=str_replace("'","'", $row["Days"]); $Event_Start_Date=str_replace("'","'", $row["Event_Start_Date"]); $Event_End_Date=str_replace("'","'", $row["Event_End_Date"]); $Start_Time=str_replace("'","'", $row["Start_Time"]); $End_Time=str_replace("'","'", $row["End_Time"]); $Event_Cost=str_replace("'","'", $row["Event_Cost"]); $Parking_Fee=str_replace("'","'", $row["Parking_Fee"]); $Activities_OnSite=str_replace("'","'", $row["Activities_OnSite"]); $Activities_Nearby=str_replace("'","'", $row["Activities_Nearby"]); $Open_to_Public=str_replace("'","'", $row["Open_to_Public"]); $Reservation_Requirement=str_replace("'","'", $row["Reservation_Requirement"]); $Highway=str_replace("'","'", $row["Highway"]); $Starting_Point=str_replace("'","'", $row["Starting_Point"]); $Ending_Point=str_replace("'","'", $row["Ending_Point"]); $Time_Needed_to_Visit=str_replace("'","'", $row["Time_Needed_to_Visit"]); $Difficulty=str_replace("'","'", $row["Difficulty"]); $Total_Area=str_replace("'","'", $row["Total_Area"]); $Peak_Elevation=str_replace("'","'", $row["Peak_Elevation"]); $Low_Point=str_replace("'","'", $row["Low_Point"]); $Address=str_replace("'","'", $row["Address"]); $City=str_replace("'","'", $row["City"]); $Zip=str_replace("'","'", $row["Zip"]); $State=str_replace("'","'", $row["State"]); $County=str_replace("'","'", $row["County"]); $Country=str_replace("'","'", $row["Country"]); $Telephone=str_replace("'","'", $row["Telephone"]); $Fax=str_replace("'","'", $row["Fax"]); $Alternative_Telephone=str_replace("'","'", $row["Alternative_Telephone"]); $email=str_replace("'","'", $row["email"]); if (strlen($Event_End_Date)>0) { if (strlen($Event_Start_Date)>0) {$Event_Dates= $Event_Start_Date." - ".$Event_End_Date;} else{$Event_Dates= $Event_End_Date;} } else {$Event_Dates= $Event_Start_Date;} if ($border % 2) {$bordercolor="\"#FFFFFF\"";} else {$bordercolor="\"#F3F3F3\"";} $table.=" \n"; $border=$border+1; } $nextpage=$alpha_code.$RecordMax; if ($RecordMax<$Winery_Count) { $table.="

Event	Event Date	City	Region	State	Country
".$Event."	".$Event_Dates."	".$City."	".$Region."	".$State."	".$Country."

\n \n \n"; } $table.="

More Events (continued)...

\n"; ?>