If I've understood correctly your record/Id number relates to a message/post. Let's say the PHP list has message numbers and this post is number 456. If I have a list of posts and sort them by user and provide the user with a numbered list of posts from 1 to N in user sequence there's VERY little chance that if I was to quote message number 47 (or whatever number it had been assigned in the sorted list) that someone else would be able to reliably find the post using number 47, but give then number 456 that is always linked to this post and this post only then they'll always be able to find it, until it's deleted ;-) Help? Graham On 9/2/07, Bill Guion <bguion@xxxxxxxxxxx> wrote: > I don't think you really want to do that, either. You don't need a > field in the database to accomplish what you are trying to do. > Execute your query to select the records you want, sorting them into > what ever order you want. When you display the records on your web > page, add a PHP variable, say $row_number, which starts at 1, and > increments by one for each row you display. > > -----===== Bill =====----- > > At 3:09 PM -0400 8/29/07, Jason Pruim wrote: > > >And what I'm looking for is away to take rows 4 and 5 and move them > >to rows 2 and 3 so the next record inserted would be row 4 :) > > > >> > >>it does not go back and fill in the holes/gaps > >> > >>-- > >>Jim Lucas > >> > >> "Some men are born to greatness, some achieve greatness, > >> and some have greatness thrust upon them." > >> > >>Twelfth Night, Act II, Scene V > >> by William Shakespeare > >> > > > >-- > > > >Jason Pruim > >Raoset Inc. > >Technology Manager > >MQC Specialist > >3251 132nd ave > >Holland, MI, 49424 > >www.raoset.com > >japruim@xxxxxxxxxx > > > -- > > Reality is the leading cause of stress, for those in touch with it. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Graham -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
