Does something change when using a secure server that would prevent a mySQL query from working? I built a custom shopping cart and it was fine, then I made the switch the the secure server and now it doesn't work at all. What am I missing?
I've done some troubleshooting and here's some of the information.
When the entire site is on a normal server, everything works just fine.
When the entire site is on a secure server, everything works just fine.
There seems to be a problem when I transition from normal to secure. The problem is not with the url's, those are fine. I echoed my SQL query, resource ID, and number of rows to see what was going on with them. After doing that, I've determined that the query wasn't working. The query looks fine, but its not getting the results properly. I'm not getting any errors, there's just no results.
It is almost as if the database under a secure server is different from the database under a normal server. Like, I'll add an item to a table under the normal server, then when I query it under the secure server, it seems to be looking somewhere else. Does that make sense? Is there a different type of connection to the database that I have to be using?
