Select a Record based on Cart Column Value

I have a PlayerID stored as a column in the cart. If I include the Player recordest in the cart display page how do I use the PlayerID from the repeating Cart region to call and display a Player Name in the cart display?

Thanks,

Mike

in advanced view, set the where clause as:

WHERE PlayerID = paramPlayerID


create a new variable as:
name: paramPlayerID
type: integer
default value: -1
runtime value: $cartName->DisplayInfo['PlayerID']


NOTE: for this to work, the recordset needs to be inside the cart display loop. If you need further help with the configuration, we can help in a premiere support appoinment

So I need to create the RS an then move the code into the repeating region?? Then echo the $row_Recordset??

yes, that is correct.

Not working. . .

Page attached:

If I display the PlayerID in the field (<?php echo $sherwin1->DisplayInfo("Name"); ?> it shows the proper PlayerID. If I display the Total rows from the Recordset it show 0 (<?php echo $totalRows_Players; ?>. If I display the parameter from the MYSQL for the RS it shows the default -1 (<?php echo $sherwin1->DisplayInfo("PlayerID"); ?>).

Seems that the RS code isn't picking up the PlayerID from the Cart, but it is there. . .

RS code starts at line 198. . .

Mike

you're welcome.

I had incorrect syntax for the run time value.

the correct syntax for the run time value is:

$sherwin1->DisplayInfo("PlayerID")

That creates an internal server error -- page doesn't load. . .

I'll need to troubleshoot directly, see the private message section.

See Below. . .