$cn = mysql_connect("localhost","stoef","meskerem") or die ("no connection");
mysql_select_db("bellydance") or die ("could not select db");
$regio = $_GET["regio"];
?>
Des photos, liens sur votre site et adresse e-mailréservé aux sponsors. Vous trouvez plus des infos sur le sponsoring ici.. Un lien sur ce site sera également considéré comme une forme de sponsoring. |
function okTRLINK($input1,$input2){
if($input1==''){return false;}else{
$tr='
';
$tr=$tr.$input2;
$tr=$tr.': | |
';
return $tr;}
}
$f1 = "danse-orientale.php";
if($regio!="") {
echo '
courses de danse orientale / stages region '.$regio.'
';
}
//else
//{
echo '
Tous les cours de danse orientale et danse du ventre, tant que les workshops en
Wallonie - Brussel et la France
';
echo '[Cliquez sur votre region]
';
//}
if($c!="") {
$select = "SELECT DISTINCT regio FROM danse_orientale WHERE active = 'y' AND land='".$c."'";
$CAT_LISTING=mysql_query($select);
echo '
';
while( $row = mysql_fetch_array($CAT_LISTING) ){
//echo ' [';
echo ' ['.$row[0].'] ';
}
/*';while( $row = mysql_fetch_array($CAT_LISTING) ){
echo '- ';
echo ''.$row[0].'
';
}
echo '
*/
echo '
';
}
#hieronder resultaten van de zoekactie
if($regio!=''){
$sql = 'SELECT * FROM danse_orientale WHERE regio = \''.$regio.'\' AND active = \'y\' ORDER BY sponsor DESC';
}
else if($ws!=''){$sql = 'SELECT * '
. ' FROM `danse_orientale` '
. ' WHERE ws = \'y\' AND active = \'y\' ORDER BY sponsor DESC'; }
//LIMIT 0, 30';
$rs = mysql_query($sql) or die ("");
//echo mysql_num_fields($rs);
$aantalVelden = mysql_num_fields($rs);
//$aantalVelden = 16;
echo '
';
function okTR($input1,$input2){
if($input1==''){return false;}else{
$tr='';
$tr=$tr.$input2;
$tr=$tr.': | ';
$tr=$tr.$input1;
$tr=$tr.' |
';
return $tr;}
}
function mailfunction($input1,$input2){
if($input1==''){return false;}else{
$tr='';
$tr=$tr.$input2;
$tr=$tr.': | |
';
return $tr;}
}
function okTRzn($input1){
if($input1==''){return false;}else{
$tr=' | ';
$tr=$tr.$input1;
$tr=$tr.' |
';
return $tr;}
}
function checkFoto($input1,$input2){
$tr='';
if($input2){$tr=$tr.'';}else{$tr=$tr.' ';}
$tr=$tr.' | ';
if($input1==''){$tr=$tr.' ';}else{$tr=$tr.$input1;}
$tr=$tr.' |
';
return $tr;}
function leegBR($input){
if($input==''){return false;}else{return $input.'
';}
}
function leeg($input){
if($input==''){return false;}else{return $input;}
}
#hieronder de gegevens
while($row = mysql_fetch_row($rs)){
echo '';
echo '';
echo $row[12];
//echo mysql_field_name($rs,14);
echo ': ';
echo ' | ';
echo $row[14];
if ($row[14]==""){
if($row[2]=="y") echo 'Workshop';
}
echo ' |
';
//echo okTR($row[12],mysql_field_name($rs,12));
#email en website indien sponsor
if($row[27]!=""){
echo checkFoto($row[13],$row[11]);
echo mailfunction($row[28],'e-mail');
echo okTRLINK($row[29],'website');
}else {echo okTRzn($row[13]);}
#info
echo okTRzn($row[23]);
echo 'place: ';
echo ' | ';
echo leegBR($row[10]);
echo leegBR($row[4]);
//echo ' ';
echo leeg($row[7]);
echo ' ';
echo $row[5];
echo ' |
';
#tijd
echo 'quand: ';
echo ' | ';
if(($row[16])!=''){echo $row[16].' leçons ';}
if(($row[2])!=''){echo $row[15];}else{
if(($row[15])!=''){echo 'de '.$row[15];}
}
//echo ' ';
echo ' |
';
//echo '';
echo okTR($row[25],'prix');
#hier de dagroosters
for($i=17;$i < 25;$i++){
if($row[$i]!=''){
echo '';
echo '';
echo mysql_field_name($rs,$i);
echo ': ';
echo ' | ';
echo $row[$i];
echo ' |
';
}else{echo '';}
}
#contactgegevens:
echo okTR($row[26],'contactez');
/*
for($i=1;$i < $aantalVelden;$i++){
echo '';
if($row[$i]!=''){
echo '';
echo mysql_field_name($rs,$i);
echo ' ['. $i.']';
echo ': ';
echo ' | ';
echo $row[$i];
echo ' | ';
echo '
';
}else{echo ' ';}
}
}
echo '';
echo '';
echo mysql_field_name($rs,8);
echo ': ';
echo ' | ';
echo $row[8];
echo ' | ';
echo '
';*/
}
echo '
';
#empty the results and close the connection
//mysql_free_result($rs);
mysql_close($cn);
?>