I need tyo number the rows resulting from a SELECT statement beginning with 0 (zero). Regardless of the record id I want the results to have an artificial field called num and it would be incremental starting with 0.

I could dothis in PHP but I need the results in javascript within the head tag, ( it this makes sense!)

Hum... I need teh array tobe numbered 01234 despite the fact that the db records don't begin with 0.

Nick

no, it doesn't make sense

why can't you do it in php?

(Hi Rudy)

I need to populate a scrip on opening before the array is created. It's an image slide show script which normally uses any number of hard coded. the files have to be numbered 01234 etc. but the id's in the database will change with the changes in files as time goes on. I'm thinking a temporary table id which starts with zero. Then in the script use and array of whoever many images the client wants to upload.

Nick

can't you just load the rows into javascript and "walk the DOM" assigning values that way?

the row don't have row numbers starting with zero! What I need is a way to add row numbers starting with zero for the rows returned by the query.

you can do that with the DOM (although i'm not the one to show you how)