It might help if you explain what you're trying to do...
I'm not getting why you're worried about the ID if it's arbitrary. In
that instance, you'd probably want to perform a query that's ordered
around something you actually care about. The only time I'd see needing
the ID (which you can include in that query) is if you were going to
perform another action on a specific row (INSERT, DELETE) where you'd
want the ID in the WHERE clause.
You wouldn't need to have the ID beforehand, because you're selecting
rows without consideration for their ID.
-Jeromie
>04182005 1517 GMT-6
>
>Ok. Thanks for answering my question but I didnt answer my own question.
>Let me ask another question then.
>
>I have a table that holds application data. The key is the appid. If
>after viewing the app it doesnt have what Im looking for, it might be
>deleted. So after a while you will have a table of applications that
>doesnt have consecutive appid's.
>
>My question is, how do you know what the next id will be if they are not
>in order?
>
>Wade
>
>
>
The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/