I think I solved my own problem. Just in case anyone else has a similar problem here's what I did.
I had created the php page by copying and renaming a similar page, I then removed the previous recordset and tried adding the new one, this was when it failed.
I checked the Server Behaviors and found a behavior that my new page did not need, once that was deleted I was able to create the new recordset.