Hi! I have the same problem (PHP MySQL). I followed the Tutorial by Matt Brown
(Recordstore on Macromedia site). The only difference was, I used a live Server
and Database. Currently going around in circles trying to fix. If anyone out
there can help, would much appreciate it. I did a test on the recordset (as per
advice by another contributor) and it was only returning one record. When
creating the Variable within the Recordset, the Tutorial gives the values to be
input; Variable Name = colname, Default = 1, and Run Time Value
=$HTTP_GET_VARS['albumid']. The problem seems to be with the Default value.
When i change it to another ID, 2 for example, it brings up that record. I
tried leaving this field blank, but it was forcing a value. I thought the value
was used for prioritising more than one variable! Still trying. Will get back
if I can solve.