Re: record position

On Thu, 18 Nov 2004 11:17:36 -0500, Jeff Jordan <jjordan@sc.rr.com> wrote: > I am selecting a specific record using Select * where username="javier". > What is the best way to extract the relative position of javier in the > table. Say it is the 50 record of 150, after the fetch_array is there a > mysqli_ that will tell me it was the 50th record? > There's no way to do this. When you run a "select" you get only the records back you asked for. In addition, the DB doesn't keep track of "where" a record is physically. In fact, it could move them around at any time. Sounds like you're looking for an auto_increment primary key. This would tell you approximately how many records had been inserted before the one you got. -- Justin Patrin