İllere Göre Okullar
$q=mysqli_query($baglan,"Select * from kategori_okullar where subid = '0' order by id ");
$newrowcount = 1;
if ($r= mysqli_fetch_array($q)) {
do {
$r['adi_x'] = str_replace (" ","-",$r['adi']);
$r['adi_x'] = $r['adi_x']."-okulları";
echo "$r[adi] Okulları ";
$newrowcount++;
}
while ($r = mysqli_fetch_array($q));
}
?>
|
|
echo "Okullar - $ktop[adi] - $k[adi]"; ?>
$id = $_GET['id'];
$q=mysqli_query($baglan,"Select * from okullar where title_s ='$id'");
$r=mysqli_fetch_array($q);
$newhit=$r['hit']+1;
$q0=mysqli_query($baglan,"update okullar set hit='$newhit' where title_s='$id'");
$r['title'] = kysil($r['title']);
$r['title_x'] = str_replace (" ","-",$r['title']);
$o['adres']=trkucuk($o['adres']);
?> |
Okul Adı : |
|
Adres : |
|
Telefon Numarası : |
|
Faks Numarası : |
|
E-mail : |
|
Bazı echo "$ktop[adi]"; ?> okulları
$dizin= $dizin+55 ;
$secenek=$r['id'];
$num_rows=$r['rsitea'];
if ($dizin>$num_rows)
{
$sayi = ($dizin%$num_rows);
}
else
{
$sayi = ($num_rows%$dizin);
}
if ($num_rows-$sayi <= 3 )
{
$sayi = $num_rows-4;
}
if ($sayi <= 0 )
{
$sayi = 0;
}
$newrowcount = 1;
$q=mysqli_query($baglan,"Select * from okullar where category ='$k[id]' order by id limit $sayi,4");
if ($r= mysqli_fetch_array($q)) {
do {
if ($newrowcount == 9999) {
$newrowcount = 0;
}
$r['title'] = kysil($r['title']);
$r['title'] = substr($r['title'],0,50);
$r['title_x'] = str_replace (" ","-",$r['title']);
if ($r['title']<>$o['title']) {
echo "
$r[title]
";
$newrowcount++; }
}
while ($r = mysqli_fetch_array($q));
}
?> |
|
|
|
|
$secenek=$dizin+$o['id']+1779 ; ?>
$dizin = $secenek + 1055 ;
$sql2=mysqli_query($baglan,"Select * from kategori_arabacc where adi like '%2010%' ");
$num_rows=mysqli_num_rows($sql2);
if ($dizin>$num_rows)
{
$sayi = ($dizin%$num_rows);
}
else
{
$sayi = ($num_rows%$dizin);
}
if ($num_rows-$sayi <= 1 )
{
$sayi = $num_rows-2;
}
if ($sayi <= 0 )
{
$sayi = 0;
}
$newrowcount = 1;
$q=mysqli_query($baglan,"Select * from kategori_arabacc where adi like '%2010%' order by adi limit $sayi,2");
if ($r= mysqli_fetch_array($q)) {
do { $k = mysqli_fetch_array(mysqli_query($baglan,"Select * from kategori_arabacc where id = '$r[subid]'"));
if ($newrowcount == 9999) {
$newrowcount = 0;
}
$r['adi'] = kysil($r['adi']);
$r['adi'] = substr($r['adi'],0,50);
$r['adi_x'] = str_replace (" ","-",$r['adi']);
echo "
";
$newrowcount++;
}
while ($r = mysqli_fetch_array($q));
}
?>
|