hi all, given a certain id # (eg 4), how would i query the value either side of it (usually 3 and 5). In theory, yes, it'd be 3 + 5, but in the case of the following table:
1 4 5 it'd be 1 + 5, and this: 3 4 7 it'd be 3 + 7. Even more interesting would be obtaining some sort of an error when there ISN'T a value higher or lower... eg 4 5 6 7 or 1 2 3 4 TIA, Justin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
