$datecheck"; $result = mysqli_query($DB_Link, $query); if (mysqli_num_rows($result) == 0){ $query = "INSERT INTO outfitter_clicklog SET outfitterid = '$id', event = 'L', ip = '$ip', price = '$eventL'"; $result = mysqli_query($DB_Link, $query); $query = "UPDATE outfitters SET balance = balance - $eventL, dailybalance = dailybalance - $eventL WHERE outfitterid = '$id'"; $result = mysqli_query($DB_Link, $query); } } $query = sprintf("SELECT outfitters.*, outfitter_pics.picture FROM outfitters LEFT JOIN outfitter_pics ON outfitters.outfitterid = outfitter_pics.outfitterid WHERE outfitters.outfitterid = '%d'", $id); $result = mysqli_query($DB_Link, $query); $row = mysqli_fetch_object($result); ?> Outfitter Profile: <? echo @$row->company; ?>
Outfitter Profile <? echo $row->company; ?>
picture) { ?>

company; ?>

slogan) { ?>

slogan; ?>

description; ?>

company; ?>
address; ?>
city." ".$row->state." ".$row->zip; ?>
country; ?>

  

yearstarted){ ?> In Business Since: yearstarted; ?>
Destinations:  regioncode." "; } ?>
Regions:  statecode." "; } ?>

    paymenttypes); foreach($paytypes as $type){ switch ($type){ case "1" : echo "
  1. Visa
    2. "; break; case "2" : echo "
  2. Master Card
    3. "; break; case "3" : echo "
  3. American Express
    4. "; break; case "4" : echo "
  4. Discover Card
    5. "; break; case "5" : echo "
  5. Check
    6. "; break; case "6" : echo "
  6. Cash
    7. "; break; case "7" : echo "
  7. Travelers Checks
    8. "; break; } } ?>
otherpaymenttype; ?>

What our Trip Members Say:
"; echo "\"".$row2->text."\"
"; if ($row2->name) echo "".$row2->name." "; if ($row2->location) echo "".$row2->location.""; echo "

"; } ?>

Trips this Professional Outfitter Offers

icon Click on the "TRIP TITLE" for more trip details...

\n"; } else{ while ($row3 = mysqli_fetch_object($result3)){ ?>

  TRIP TITLE:

DESTINATION:

REGION:

TRIP DURATION:

PRICE RANGE:

No Trips Listed

name; ?>

region; ?>

state; ?>

duration; echo " day"; if ($row3->duration != 1) echo "s"; ?>

pricerange){ case "10" : echo "$10 - $50"; break; case "50" : echo "$51 - $250"; break; case "251" : echo "$251-$450"; break; case "451" : echo "$451-$650"; break; case "651" : echo "$651-$850"; break; case "851" : echo "$851-$1050"; break; case "1051" : echo "$1051-$2000"; break; case "2001" : echo "$2001-$3000"; break; case "3001" : echo "$3001-$4000"; break; case "4001" : echo "$4001-$5000"; break; case "5001" : echo "$5001-above"; break; } ?>