Mark Hensler — Wed, 30 Oct 2002 07:38:27 +0000

Very nice. Congrats!

fifeclub — Wed, 30 Oct 2002 05:30:35 +0000

Both ways worked, but I happen to go with Mark's method. Works like a charm which is great because this was the last piece to my functionality puzzle and now I can work on design. Thanks again.

By the way, I'm proud to say that from your example which showed me the formatting, I was able to figure out how to do something else on my own. Yea, I'm a programmer now! Okay not quite - but I'm still proud that I found a solution to this problem: I ~~also~~ want to have individual states as a possible variable, but how do I do this without having to setup a different line for each state? Here's what I put at the end after the 'named regions':

<?php
$location['self'] = \"'$region'\";

if (!in_array($region, array_keys($location))) {
  $region = \"self\"; 
}
?>

fifeclub — Tue, 29 Oct 2002 12:54:29 +0000

Thanks. Both look like they do exactly what I was looking for. I'll give 'em both a try.

Mark Hensler — Tue, 29 Oct 2002 00:10:47 +0000

I would use an array...

<?php
$location['pacific'] = \"'WA','OR','CA','NV'\";
$location['newengland'] = \"'CT','RI','MA','VT','NH','ME'\";

if (!in_array($region, array_keys($location))) {
  $region = \"pacific\"; // Default Region/Location
}

$query = \"SELECT * FROM alumni WHERE state IN (\".$location[$region].\")\";
?>

necrotic — Mon, 28 Oct 2002 22:50:34 +0000

If I understand you correctly you don't want the state, just the region. If that's it then here is how I would do it:

<?php
// Define Locations...
$pacific = \"'WA','OR','CA','NV'\";
$newengland = \"'CT','RI','MA','VT','NH','ME'\";
//....... Add More if Desired

if (!isset($region)) {
  $location = $pacific; // Default Region/Location
} else if ($region == 'pacific') {
  $location = $pacific;
} else if ($region == 'centeral') {
  $location = $newengland;
}
// ....... Continue Code
?>