Incrementing Number in Repeat Region - Help!

[Tom]

Anyone help on this? PHP/MySQL

I have a repeat region displaying records from orders in a CSV format:

CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Book,25. 95,???
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Poster,1 0.00,???
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Video,49 .95,???

I need to have a column where I can assign each item in the order a
different number incrementally i.e. 1st item = 1, 2nd = 2 etc.

The ??? (last column) in the above records is where I will insert this
incremental number to produce (hopefully):

CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Book,25. 95,1
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Poster,1 0.00,2
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Video,49 .95,3

Can anyone help me figure out how to add this incrementing number inside
this repeating region? I have a distinct orderID (in this case its 18, 2nd
column) that I can reference from.

Thanks! - Tom

[Michael Austin]

Tom wrote:

Anyone help on this? PHP/MySQL

I have a repeat region displaying records from orders in a CSV format:

CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Book,25. 95,???
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Poster,1 0.00,???
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Video,49 .95,???

I need to have a column where I can assign each item in the order a
different number incrementally i.e. 1st item = 1, 2nd = 2 etc.

The ??? (last column) in the above records is where I will insert this
incremental number to produce (hopefully):

CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Book,25. 95,1
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Poster,1 0.00,2
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Video,49 .95,3

Can anyone help me figure out how to add this incrementing number inside
this repeating region? I have a distinct orderID (in this case its 18, 2nd
column) that I can reference from.

Thanks! - Tom

First, You really should consider normalizing your data a bit more to REDUCE the
repeated data...

you should have a table with the order innformation.

ID, USER, DATE, CARRIER, SITE, STATE
18, CALJOE

and a data table

ID, ITEM, AMOUNT, ITEM_NUM
18, CD, 24.00, 1
....

and insert the ITEM_NUM from the form data.

or if you just need this for display purposes

loop through the results of the query and add a counter value. I will leave the
code as a learning experience.
--
Michael Austin.
Consultant - Available.
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

[Tom]

Thanks for the reply,

In this case I'm building an order import CSV for Peachtree Acct. from the
OScommerce store. I can't rewrite the OScommerce tables, so I needed to work
thru it.

Actually the solution was too easy:

$i = 1;
$i ++:

Thanks
"Michael Austin" <ma*****@firstd basource.com> wrote in message
news:ry******** *********@newss vr24.news.prodi gy.com...

Tom wrote:

Anyone help on this? PHP/MySQL

I have a repeat region displaying records from orders in a CSV format:

CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Book,25. 95,???
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Poster,1 0.00,???
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Video,49 .95,???

I need to have a column where I can assign each item in the order a
different number incrementally i.e. 1st item = 1, 2nd = 2 etc.

The ??? (last column) in the above records is where I will insert this
incremental number to produce (hopefully):

CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Book,25. 95,1
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Poster,1 0.00,2
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBS ITE,CA,Video,49 .95,3

Can anyone help me figure out how to add this incrementing number inside
this repeating region? I have a distinct orderID (in this case its 18, 2nd column) that I can reference from.

Thanks! - Tom
First, You really should consider normalizing your data a bit more to

REDUCE the repeated data...

you should have a table with the order innformation.

ID, USER, DATE, CARRIER, SITE, STATE
18, CALJOE

and a data table

ID, ITEM, AMOUNT, ITEM_NUM
18, CD, 24.00, 1
...

and insert the ITEM_NUM from the form data.

or if you just need this for display purposes

loop through the results of the query and add a counter value. I will leave the code as a learning experience.
--
Michael Austin.
Consultant - Available.
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)