TWIB Transcripts

This Week in Business in your area. Enter your state in the field below and click the \"search\" button."; echo "

"; echo ""; echo "

Enter your state:

"; } $num = -1; if ($show) { mysql_connect("oldev-cr01.pbs.org", "wetaaccess", "9secnav8"); $query = "SELECT * FROM stations WHERE state LIKE '%$key%' ORDER BY state,city"; $res = mysql("wetadb","$query"); $num = mysql_numrows($res); if ($num==1) { echo "$num station was found in your state.

\n\n"; } elseif ($num>1) { echo "$num stations were found in your state.

\n\n"; } elseif ($num == 0) { echo "No stations were found in your state.

\n\n"; } if ($num > 0) { echo ""; echo ""; echo ""; echo ""; $i = 0; while ($i<$num) { $ID = mysql_result($res,$i,"ID"); $station = mysql_result($res,$i,"station"); $city = mysql_result($res,$i,"city"); $state = mysql_result($res,$i,"state"); $day = mysql_result($res,$i,"day"); $starttime = mysql_result($res,$i,"starttime"); $cur_num = $i +1; if ($cur_num%2==0) { $bgcolor = fafad2; } else { $bgcolor = ffffff; } echo ""; echo ""; echo ""; $i++; } echo "
Station City, State When to Watch
$station $city, $state $day at $starttime

\n"; } mysql_connect("oldev-cr01.pbs.org", "wetaaccess", "9secnav8"); $query = "SELECT * FROM stations WHERE altstates LIKE '%$key%' ORDER BY state,city"; $res = mysql("wetadb","$query"); $num = mysql_numrows($res); if ($num==1) { echo "$num station was found in neighboring states.

\n\n"; } elseif ($num>1) { echo "$num stations were found in neighboring states.

\n\n"; } elseif ($num == 0) { echo "No stations were found in neighboring states.