isn't it as simple as...
select id,lot_id,lot_type from scrap_table
where id >= 1932 and id <= 1942
order by id limit 10;
?
cheers,
P
>
> which should give me records 1932 - 1942 like this...
>
> +------+----------+----------+
> | id | lot_id | lot_type |
> +------+----------+----------+
> | 1942 | 0034906 | F |
> | 1941 | 0100308 | F |
> | 1940 | 0036309 | S |
> | 1939 | 0033503 | F |
> | 1938 | 0034108E | D |
> | 1937 | 0034712 | F |
> | 1936 | 0029404 | F |
> | 1935 | 0032706 | F |
> | 1934 | 0029404 | F |
> | 1933 | 0100307 | F |
> | 1932 | 0100404 | F |
> +------+----------+----------+
>
>
> any suggestions?
>
> Ron
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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