select while insert?
===

am not sure if it's possible but I'm trying to do an insert while selecting for a value to do a +1. Reason I'm doing this because my column is auto increments, but the values are all over the places.

here's what i have so far and it won't let me do the insert:

    insert into channels set chanid=(select chanid from channels where parent=2 order by chanid desc limit 1)+1