Using ADODB with PHP, not calling columns in correct order messes up results.

[iarp]

Hey there, i have a stored procedure that passes me information from the techs database.

 

I'm stuck using some type of ADODB system, I've never used it in the past. But i'm finding, if i have 50 columns and i call column 29 and then try to call on column 15 (using their names not the number) column 15 comes through as blank.

 

But if i call column 15 and then 29 everything works.

 

Not sure how to do this, i cannot modify the Stored Procedure to my column ordering on the web page, and i have a lot of columns. At first i thought of maybe putting the data in the order of the SP's results into variables and then using the variables as i see fit, just there's a lot of columns i'm pulling.

[Christian F.]

Can you show us the code where you create and use these columns/rows?

[Jessica]

The way you've phrased this doesn't make much sense, you don't "Call on" columns. Post your queries and relevant code.

[iarp]

$teams = $db->Execute("EXEC Sports.dbo.TeamMembers");

while(!$teams->EOF) {
    echo $teams->Fields['RdPk'];
    echo $teams->Fields['Position'];
    echo $teams->Fields['Bchk'];
    echo $teams->Fields['Rating'];
    $teams->MoveNext();
}
$teams->Close();

 

Mind you that is a small list of columns. But the SP returns it in this order

 

1. Position

2. RdPk

3. Rating

4. Bchk

[Jessica]

We still need more information, especially regarding Sports.dbo.TeamMembers.

What is the output now? Have you verified the data in the DB is correct?

[iarp]

I run the exact same SP within the database itself and all data is correct, all data is present and everything has information, every cell.

 

But within the $teams->Fields entries, they are empty depending on what order i call them in.

 

This is a paste of the columns i have to deal with. There are many others, another SP i'm calling from has many many more columns.

 

PlayerIds
LeagueName
DivisionName
SubDivisionName
SeasonName
DraftListrOUNDNumber
DraftListPickNumber
RndPck
DraftStartPosition
Team
LastName
FirstName
HCId
SMId
Season
League
Division
PlayerAvailable
PlayerType
BChk
DOBY
DateOfBirth
FullName
Avl
PlayerType
MF
Rank
Rating
Goals
Assists
Shoots
Position