Variable set thru Recordset
HI Jason and Webassist.
I have been working on a recordset thru a different thread with Jenny I. I can get the recordset to work in phpmyadmin, but when I apply the same recordset to DM, I get an Undefined Index, which I believe is the variable is not being set correctly or at all.
Here is the recordset. I can run the recordset in DM and nothing will populate in the Options1.OptionName thru Options4.OptionName. Once I change the bindings, this is the fault. The changed bindings are below the recordset.
Any Ideas?
Mike D
SELECT CompanyOptions.CoOptionsID, CompanyOptions.CompanyID, CompanyOptions.Op1, CompanyOptions.Op2, CompanyOptions.Op3, CompanyOptions.Op4, CompanyIndex.CoName, Options1.OptionName, Options2.OptionName, Options3.OptionName, Options4.OptionName
FROM CompanyOptions
LEFT JOIN Options AS Options1 ON CompanyOptions.Op1 = Options1.OptionsID
LEFT JOIN Options AS Options2 ON CompanyOptions.Op2 = Options2.OptionsID
LEFT JOIN Options AS Options3 ON CompanyOptions.Op3 = Options3.OptionsID
LEFT JOIN Options AS Options4 ON CompanyOptions.Op4 = Options4.OptionsID
LEFT JOIN CompanyIndex ON CompanyOptions.CompanyID = CompanyIndex.CompanyID
<td><?php echo $row_rsOptions['CoName']; ?></td>
<td><?php echo $row_rsOptions['Options1.OptionName']; ?></td>
<td><?php echo $row_rsOptions['Options2.OptionName']; ?></td>
<td><?php echo $row_rsOptions['Options3.OptionName']; ?></td>
<td><?php echo $row_rsOptions['Options4.OptionName']; ?></td>