I'm a newb, and i was wondering if my prob is obvious to anybody.
I just used a trial copy of Dreamweaver MX to create a PHP mysql site locally on OSX, doing a bit of raw code work to get it all to look OK. Using phpmyadmin 2.5.6, PHP 4.3.2 and mysql 4.0.15.
All is good and local site is good and works. I put onto a remote linux RH 7.2 box running phpmyadmin 2.5.6, PHP 4.0.6 and mysql 3.23.58, I hand created the tables by copy pasting into a terminal. Problem is, although remote PHP connects to remote mySQL, queries result in incorrect data. I can get remote PHP to connect to my local mysql and all is good. The only difference between remote and local sites is the name of the Database. local is system_contacts (OSX) mysql variable for case insensitivity is set to 1 (ON) and remote name is System_Contacts (Linux) with mysql variable for case insensitivity set to 0 (OFF).
Or could my problem be that I should be running a newer version of mysql on the remote Linux box?
