I am sure i have seen what I am after on here before but I can not find it
What I need to do is the following
Once i have a result from the database I need to loop though the result to create a datastring
I have
Code: Select all
TotalCol = mysql_num_fields(MySQLOut)
TotalRow = mysql_num_rows(MySQLOut)
If debugmode = 1 Then print TotalRow
Row = mysql_fetch_row(MySQLOut)
54,Ca,Dave's SuperMarkert Ltd
54,Ca,Hardingstone
so the feilds are lineaglinment(0) linefont (1) linetext (2)
Does anyone have any examples of how to loop though a MySQL Row result? I am sure I need to use a For Loop something like
For i =- 0 to TotalRow
RecipitHeadder += *row[0] & "," & *row[1] &"," & row[2]
next i