Maybe I'm reading your question wrong, but what you are asking isn't
possible and more importantly doesn't make sense.

I think you're thinking of a database table as you'd think about say an
excel worksheet (in that it's ordered).   tables aren't ordered in that
way.  Think about a table as um... a pond.  And each fish in that pond is
a row (or tuple or record).  The fish can swim anywhere they want in that
pond so there is no "beginning" or "end".  However, if you've tattoed each
fish with the number indicating it's insertion into the pond (ie the first
fish into the pond got 1, the second gets 2, etc.) then when you select
your fish you can order it by those numbers.

Heh... how's that for a wacky analogy.

Depending on the physical order of rows in a database table is going to
get you into trouble down the road.

good luck!

On Mon, 17 Dec 2001, Mike Krisher wrote:

> I suppose this is more of a SQL question, but how do I insert a row into a
> table right before the very last row in the table. I am sure there is a way
> to insert a row other than just at the beginning or end of a table but I
> can't find the syntax on the mySQL site. Anyone know?
>
> » Michael Krisher
>   [EMAIL PROTECTED]
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to