Re: Pragmatically changing a "Record Number"

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@raoset.com

-- Reality is the leading cause of stress, for those in touch with it.