|
Medlem
|
|
Reg.datum: Jan 2005
Inlägg: 83
|
|
|
Medlem
Reg.datum: Jan 2005
Inlägg: 83
|
$a = mysql_fetch_row(mysql_query("SELECT id, link, text FROM tabell WHERE typ = $typ order by id Limit 1"));
$b = mysql_fetch_row(mysql_query("SELECT id, link, text FROM tabell WHERE typ = $typ and id > ". $a['id'] ." order by id Limit 1"));
Allternativt:
$a = mysql_fetch_row(mysql_query("SELECT id, link, text FROM tabell WHERE typ = $typ order by id desc Limit 1"));
$b = mysql_fetch_row(mysql_query("SELECT id, link, text FROM tabell WHERE typ = $typ and id < ". $a['id'] ." order by id desc Limit 1"));
om du vill ha i omvänd ordning
osv.. något i den stilen borde funka.
|