Önceki ve Sonraki Ürün Link Kodu |
11 Mesajlar | 2.365 Okunma | ||
select * from urun where id = (select min(id) from urun where id > 4) LIMIT 1
SELECT * FROM urun WHERE id > 4 ORDER BY id LIMIT 1;select * from urun where id = (select min(id) from urun where id > 4) LIMIT 1
SELECT * FROM urun WHERE id > 4 ORDER BY id LIMIT 1;
$q = mysql_query("SELECT id FROM tablo WHERE id < '$suankideger' ORDER BY id DESC LIMIT 1");
$b = mysql_fetch_array($q);
echo $b[id];$q = mysql_query("SELECT id FROM tablo WHERE id > '$suankideger' ORDER BY id ASC LIMIT 1");
$a = mysql_fetch_array($q);
echo $a[id];Önceki Ürün | Sonrak, ÜrünMuhsin ASLAN adlı üyeden alıntı
Onceki icin
$q = mysql_query("SELECT id FROM tablo WHERE id < '$suankideger' ORDER BY id DESC LIMIT 1");
$b = mysql_fetch_array($q);
echo $b[id];
$q = mysql_query("SELECT id FROM tablo WHERE id > '$suankideger' ORDER BY id ASC LIMIT 1");
$a = mysql_fetch_array($q);
echo $a[id];
Önceki Ürün | Sonrak, Ürün