TEILNEHMER


CDI4*

getQuery(true); $query->select($db->quoteName(array('nation', 'rider', 'horsename', 'horseinfo', 'flag' ))); $query->from($db->quoteName('tbl_sl19')); $query->where($db->quoteName('eventcode') . ' LIKE '. $db->quote('CDI4*')); $query->order('nation ASC, rider ASC'); $db->setQuery($query); //echo $query; $rows = $db->loadAssocList(); //print_r($row); foreach( $rows as $row ) { $this_reiter_nation = $row['nation']; // the retrieved value of "nation" $this_reiter_flagge = $row['flag']; // the retrieved value of "nation" $this_reiter_name = $row['rider']; // the retrieved value of "reiter" $this_reiter_pferdename = $row['horsename']; // the retrieved value of "username" $this_reiter_abstammung = $row['horseinfo']; // the retrieved value of "username" $color = ($i % 2) ? "#e0eaf4" : "#f4f4f4"; echo ""; echo ""; echo ""; echo ""; echo ""; /**echo "";**/ echo ""; $i++; } ?>
Nation
Teilnehmer Pferd Abstammung
".$row["rider"]."".$row["horsename"]."".$row["horseinfo"]."".$row["kategorie"]."



CDICh-A

getQuery(true); $query->select($db->quoteName(array('nation', 'rider', 'horsename', 'horseinfo', 'flag' ))); $query->from($db->quoteName('tbl_sl19')); $query->where($db->quoteName('eventcode') . ' LIKE '. $db->quote('CDICh-A')); $query->order('nation ASC, rider ASC'); $db->setQuery($query); //echo $query; $rows = $db->loadAssocList(); //print_r($row); foreach( $rows as $row ) { $this_reiter_nation = $row['nation']; // the retrieved value of "nation" $this_reiter_flagge = $row['flag']; // the retrieved value of "nation" $this_reiter_name = $row['rider']; // the retrieved value of "reiter" $this_reiter_pferdename = $row['horsename']; // the retrieved value of "username" $this_reiter_abstammung = $row['horseinfo']; // the retrieved value of "username" $color = ($i % 2) ? "#e0eaf4" : "#f4f4f4"; echo ""; echo ""; echo ""; echo ""; echo ""; /**echo "";**/ echo ""; $i++; } ?>
Nation
Teilnehmer Pferd Abstammung
".$row["rider"]."".$row["horsename"]."".$row["horseinfo"]."".$row["kategorie"]."



CDIJ

getQuery(true); $query->select($db->quoteName(array('nation', 'rider', 'horsename', 'horseinfo', 'flag' ))); $query->from($db->quoteName('tbl_sl19')); $query->where($db->quoteName('eventcode') . ' LIKE '. $db->quote('CDIJ')); $query->order('nation ASC, rider ASC'); $db->setQuery($query); //echo $query; $rows = $db->loadAssocList(); //print_r($row); foreach( $rows as $row ) { $this_reiter_nation = $row['nation']; // the retrieved value of "nation" $this_reiter_flagge = $row['flag']; // the retrieved value of "nation" $this_reiter_name = $row['rider']; // the retrieved value of "reiter" $this_reiter_pferdename = $row['horsename']; // the retrieved value of "username" $this_reiter_abstammung = $row['horseinfo']; // the retrieved value of "username" $color = ($i % 2) ? "#e0eaf4" : "#f4f4f4"; echo ""; echo ""; echo ""; echo ""; echo ""; /**echo "";**/ echo ""; $i++; } ?>
Nation
Teilnehmer Pferd Abstammung
".$row["rider"]."".$row["horsename"]."".$row["horseinfo"]."".$row["kategorie"]."



CDIP

getQuery(true); $query->select($db->quoteName(array('nation', 'rider', 'horsename', 'horseinfo', 'flag' ))); $query->from($db->quoteName('tbl_sl19')); $query->where($db->quoteName('eventcode') . ' LIKE '. $db->quote('CDIP')); $query->order('nation ASC, rider ASC'); $db->setQuery($query); //echo $query; $rows = $db->loadAssocList(); //print_r($row); foreach( $rows as $row ) { $this_reiter_nation = $row['nation']; // the retrieved value of "nation" $this_reiter_flagge = $row['flag']; // the retrieved value of "nation" $this_reiter_name = $row['rider']; // the retrieved value of "reiter" $this_reiter_pferdename = $row['horsename']; // the retrieved value of "username" $this_reiter_abstammung = $row['horseinfo']; // the retrieved value of "username" $color = ($i % 2) ? "#e0eaf4" : "#f4f4f4"; echo ""; echo ""; echo ""; echo ""; echo ""; /**echo "";**/ echo ""; $i++; } ?>
Nation
Teilnehmer Pferd Abstammung
".$row["rider"]."".$row["horsename"]."".$row["horseinfo"]."".$row["kategorie"]."



CDIU25

getQuery(true); $query->select($db->quoteName(array('nation', 'rider', 'horsename', 'horseinfo', 'flag' ))); $query->from($db->quoteName('tbl_sl19')); $query->where($db->quoteName('eventcode') . ' LIKE '. $db->quote('CDIU25')); $query->order('nation ASC, rider ASC'); $db->setQuery($query); //echo $query; $rows = $db->loadAssocList(); //print_r($row); foreach( $rows as $row ) { $this_reiter_nation = $row['nation']; // the retrieved value of "nation" $this_reiter_flagge = $row['flag']; // the retrieved value of "nation" $this_reiter_name = $row['rider']; // the retrieved value of "reiter" $this_reiter_pferdename = $row['horsename']; // the retrieved value of "username" $this_reiter_abstammung = $row['horseinfo']; // the retrieved value of "username" $color = ($i % 2) ? "#e0eaf4" : "#f4f4f4"; echo ""; echo ""; echo ""; echo ""; echo ""; /**echo "";**/ echo ""; $i++; } ?>
Nation
Teilnehmer Pferd Abstammung
".$row["rider"]."".$row["horsename"]."".$row["horseinfo"]."".$row["kategorie"]."



CDIY

getQuery(true); $query->select($db->quoteName(array('nation', 'rider', 'horsename', 'horseinfo', 'flag' ))); $query->from($db->quoteName('tbl_sl19')); $query->where($db->quoteName('eventcode') . ' LIKE '. $db->quote('CDIY')); $query->order('nation ASC, rider ASC'); $db->setQuery($query); //echo $query; $rows = $db->loadAssocList(); //print_r($row); foreach( $rows as $row ) { $this_reiter_nation = $row['nation']; // the retrieved value of "nation" $this_reiter_flagge = $row['flag']; // the retrieved value of "nation" $this_reiter_name = $row['rider']; // the retrieved value of "reiter" $this_reiter_pferdename = $row['horsename']; // the retrieved value of "username" $this_reiter_abstammung = $row['horseinfo']; // the retrieved value of "username" $color = ($i % 2) ? "#e0eaf4" : "#f4f4f4"; echo ""; echo ""; echo ""; echo ""; echo ""; /**echo "";**/ echo ""; $i++; } ?>
Nation
Teilnehmer Pferd Abstammung
".$row["rider"]."".$row["horsename"]."".$row["horseinfo"]."".$row["kategorie"]."



CDIYH

getQuery(true); $query->select($db->quoteName(array('nation', 'rider', 'horsename', 'horseinfo', 'flag' ))); $query->from($db->quoteName('tbl_sl19')); $query->where($db->quoteName('eventcode') . ' LIKE '. $db->quote('CDIYH')); $query->order('nation ASC, rider ASC'); $db->setQuery($query); //echo $query; $rows = $db->loadAssocList(); //print_r($row); foreach( $rows as $row ) { $this_reiter_nation = $row['nation']; // the retrieved value of "nation" $this_reiter_flagge = $row['flag']; // the retrieved value of "nation" $this_reiter_name = $row['rider']; // the retrieved value of "reiter" $this_reiter_pferdename = $row['horsename']; // the retrieved value of "username" $this_reiter_abstammung = $row['horseinfo']; // the retrieved value of "username" $color = ($i % 2) ? "#e0eaf4" : "#f4f4f4"; echo ""; echo ""; echo ""; echo ""; echo ""; /**echo "";**/ echo ""; $i++; } ?>
Nation
Teilnehmer Pferd Abstammung
".$row["rider"]."".$row["horsename"]."".$row["horseinfo"]."".$row["kategorie"]."



Letzte Aktualisierung am: getQuery(true); $query->select('lastchange'); $query->from($db->quoteName('tbl_sl19')); $query->where($db->quoteName('id') . ' LIKE '. $db->quote('1')); $db->setQuery($query); //echo $query; $column= $db->loadColumn(); print_r($column['0']); //print_r($row); ?>