this is apparently a very difficult question, but i will try again today.
I need to spit out some data in a particular way, to see how: look at this link: http://mywebgenius.net/one.htm
here is the query I am using:
SELECT TBL_ACCOUNT.UserUID, TBL_ACCOUNT.ID, TBL_ACCOUNT.UserLevel, TBL_ACCOUNT.PCCount, TBL_ACCOUNT.Enter_ShardNum
TBL_PC.PCUID, TBL_PC.FirstName, TBL_PC.LastName, TBL_PC.Gender
FROM TBL_ACCOUNT INNER JOIN
TBL_PC ON TBL_ACCOUNT.UserUID = TBL_PC.UserUID
where TBL_ACCOUNT.ID like '%red%'
I am using a while loop like this>> while($row = mssql_fetch_array($qry)) to spit out the data and then $row['ID'], etc. to get the exact field, but think i need a do..while loop or for loop to get my data to show the way I want it to. I tried a nested while loop, but that didn't work, or perhaps I am not coding correctly.
Someone suggested a foreach loop and a while, but it's not working. Can anyone help me by showing the coding for the please? - Thanks in advance.