question about numbering record in a better way

[bbmak]

hi:
right now i am using this to number my records. Are there any better way or functions to number records?
i=1;
while () {
echo "$i";
i++;
}

[CrzySdrs]

What kind of records are you numbering? If they are coming from a db, you could just have it so that it prints out a number when every row is used.

If you are just outputting numbers with no data, I don't really see the point. I assume since you are dynamicly generating numbers, you have data to go with it.

If we see more code, we could make a better assumption.

[bbmak]

What kind of records are you numbering? If they are coming from a db, you could just have it so that it prints out a number when every row is used.

If you are just outputting numbers with no data, I don't really see the point. I assume since you are dynamicly generating numbers, you have data to go with it.

If we see more code, we could make a better assumption.

yes it is records from database. how do i number them in a better way?

[mrruben5]

Running mysql? make a field id, and auto_increment it.

[marek_mar]

It's a good way if you wan't to number them display wise eg. for an ordered list.

[bbmak]

Running mysql? make a field id, and auto_increment it.

for my auto_increment, it is not really in order, some records in the middle have deleted

[raf]

i don't quite understand what you need.

in your db, you usually make the Primary Key in your table an auto_increment. Because it is used to define relationschips with other tables (through Primary Key - Foreign Key relationships), you can not change it to have a nice sequence without any missing number. It's also irrelevant then that there are holes in the sequence.

or are these numbers supposed to indicate some sort of usable order?