$notnew or $rinkstable.datedown is null) and
$rinkstable.club='Y' GROUP BY state";*/
$statelist=mysql_query($query);
$numstates=mysql_numrows($statelist);
$i=0;
while ($i<$numstates)
{
$statename = mysql_result($statelist,$i,"statename");
echo "$statename";
if ($i<($numstates-1))
{ echo ", "; }
$i++;
}
?>
$notnew and ($rinkstable.datedown>$notnew or
$rinkstable.datedown is null) and $rinkstable.club='Y' and
$rinkstable.state=$regionstable.statename and $regionstable.regionname='$region'";
/* print $newrinks; */
$newrinksquery=mysql_query($newrinks) or die("Query to find new rinks failed.");
$numnewrinks=mysql_numrows($newrinksquery);
?>
Total club websites in :
New clubs in region since
This page lists roller skating clubs' websites. I know I'm missing
quite a few, so please email
me (or use this form - it
says "rinks" but it'll work for clubs, too!) with additions! Thanks.
$notnew or $rinkstable.datedown is null) and
and $rinkstable.club='Y'
*/
$rink_result = mysql_query($query) or die("Rink query failed.");
$rinkrows=mysql_numrows($rink_result);
/*echo "$query\n";*/
$i=0;
$oldstate='';
while($i<$rinkrows)
{
$currstate=mysql_result($rink_result,$i,"state");
$datedown=mysql_result($rink_result,$i,"unix_timestamp(datedown)");
$roller_rink=mysql_result($rink_result,$i,"club");
$rectype=mysql_result($rink_result,$i,"rectype");
// Check for new state; if so handle it
if ($currstate <> $oldstate) {
if ($oldstate <> '')
{
if ($statecount==0)
{
echo "
\n";
echo "
No active links - sorry!
\n";
}
echo "
\n";
}
echo "
$currstate
\n";
$statecount=0;
$oldstate = $currstate;
}
// Handle the "See also" records
if ($roller_rink=="Y" and $datedown<=$notnew and $rectype=="A")
{
$name=mysql_result($rink_result,$i,"name");
$link=mysql_result($rink_result,$i,"link");
echo "
See also: ";
echo "$name";
if ($datedown != '') {
echo " ($datedowndisplay - Appears to be down)";
}
echo "
\n";
}
// handle the rink records
if ($roller_rink=="Y" and $datedown<=$notnew and $rectype=="R")
{
if ($statecount==0)
echo "
\n";
$city=mysql_result($rink_result,$i,"city");
$name=mysql_result($rink_result,$i,"name");
$link=mysql_result($rink_result,$i,"link");
$otherinfo=mysql_result($rink_result,$i,"otherinfo");
$dateadded=str_replace('-','',mysql_result($rink_result,$i,"dateadded"));
$dateupdated=str_replace('-','',mysql_result($rink_result,$i,"dateupdated"));
/* handle the otherinfo and datedown fields */
if (trim($otherinfo)<>'')
{
$info = " " . $otherinfo;
if ($datedown <> '')
{ $info .= " (" . date('n/j/Y',$datedown) . " - appears to be down)"; }
}
else
{
if ($datedown <> '')
{ $info = " (" . date('n/j/Y',$datedown) ." - appears to be down)"; }
else
{ $info = ""; }
}
echo "
![\"--NEW!--\"](\"../images/new.gif\"){kind=small}
";
$highlight=1;
}
elseif ($dateupdated > $notnew) { /* updated rink? */
echo "![\"--UPDATED!--\"](\"../images/updated.gif\")
";
$highlight=1;
}
echo "$city: $name";
if ($highlight)
{ echo ""; }
echo "$info