PHP expert |
|
ik weet niet of mysql lowest en highest kent, maar als die dat kent dan:
SELECT * FROM _tabel_
WHERE ID = ___hier_A___
AND nummer =
(SELECT highest(lowest(MAX(nummer), ___hier_B___), MIN(nummer))
FROM _tabel_
WHERE ID = ___hier_A____)
SELECT * FROM _tabel_ WHERE ID = ___hier_A___ AND nummer = (SELECT highest(lowest(MAX(nummer), ___hier_B___), MIN(nummer)) FROM _tabel_ WHERE ID = ___hier_A____)
of iets in die aard, you get the picture i hope
titjes schreef: CODETAGS VENT |