Adding Records at Start

[Mark Maslowski]

> I think you have to include your sort field with your select so:
> 
> SELECT DISTINCT level_1, ID FROM resources ORDER BY ID
> 
> Hope that helps.

Nope. The DISTINCT is just ignored, still leaving me multiples. Now, I could
use a repeat loop and delete the duplicate entries, but I should be able to
do this with the database query.

Thanks anyway.

- Mark

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Mark D. Maslowski
Partner/Designer/Programmer

MAJICo - The Mark and June Interactive Company
Serving Northern California - from Napa to Monterey!
www.majico.com

831-336-3343 voice       831-336-3353 fax

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*