[Timofey]

Har löst detta nu. Jag förstår inte heller vad jag menar

Det fick bli en massa rader med förfrågningar och if-satser...

if ($cvalue=="dju")
 {
$a = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 1"));
$b = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 1,2"));
$c = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 2,3"));
$d = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 3,4"));
$e = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 4,5"));
$f = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 5,6"));
$g = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 6,7"));
$h = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 7,8"));
$i = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 8,9"));
$j = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 9,10"));
$k = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 10,11"));
$l = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 11,12"));
$m = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 12,13"));
$n = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 13,14"));
$o = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 14,15"));
$p = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='dju' ORDER BY `id` DESC LIMIT 15,16"));
 }
elseif ($cvalue=="lan")
 {
$a = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 1"));
$b = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 1,2"));
$c = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 2,3"));
$d = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 3,4"));
$e = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 4,5"));
$f = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 5,6"));
$g = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 6,7"));
$h = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 7,8"));
$i = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 8,9"));
$j = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 9,10"));
$k = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 10,11"));
$l = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 11,12"));
$m = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 12,13"));
$n = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 13,14"));
$o = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 14,15"));
$p = mysql_fetch_row(mysql_query("SELECT link, text, cat, id FROM foto WHERE cat='lan' ORDER BY `id` DESC LIMIT 15,16"));
 }

...

else
 {
$a = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y)"));
$b = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-1)"));
$c = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-2)"));
$d = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-3)"));
$e = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-4)"));
$f = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-5)"));
$g = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-6)"));
$h = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-7)"));
$i = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-8)"));
$j = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-9)"));
$k = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-10)"));
$l = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-11)"));
$m = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-12)"));
$n = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-13)"));
$o = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-14)"));
$p = mysql_fetch_row(mysql_query("SELECT link, text FROM foto WHERE id IN ($y-15)"));
 }

Får väl ta och förbättra koden senare. Huvudsaken just nu är att det ska funka... och det gör det ... bara lite segt.