<?php
/*
 * Created on Feb 16, 2010
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 *
 * TODO: Edit MySQL DB user and passwd below! 
*/
 
  
  $tour = $_GET['tour_id'];
  $participant = $_GET['participant_id'];

  $db = mysqli_connect('localhost', 'user', 'passwd', 'trcr')
    or die('Fehler beim Verbinden mit MySQL-Server.');
  mysqli_set_charset($db, "latin1_swedish_ci");
    
  $sql = "SELECT lat, lon FROM trcr_trackpoints WHERE tour_id=$tour AND participant_id=$participant";
  $ergebnis = mysqli_query($db, $sql)
    or die('Fehler bei Datenbankabfrage.');

  echo "<trk>\n";
  
  while ($zeile = mysqli_fetch_array($ergebnis)) {
    $lon = $zeile['lon'];
    $lat = $zeile['lat'];
 
    echo '  <trkpt ';
 
    
    echo "lat=\"" . $lat . "\" lon=\"" . $lon . "\"/>\n";
  }
  
   echo "</trk>\n";
  
  mysqli_close($db);
?>