RE: [PHP-WIN] Windows and Linux

From: Date: Mon, 19 Mar 2001 19:42:57 +0000
Subject: RE: [PHP-WIN] Windows and Linux
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-6150@lists.php.net to get a copy of this message
hi, check your sql query, especially the table and column names. mysql for windows is not case sensitive, whereas mysql for linux is. so under linux, not only the spelling must match but also the used case. chris. -----Original Message----- From: Mujahid [mailto:mwazir@vsnl.com] Sent: lundi 19 mars 2001 20:31 To: php-windows@lists.php.net Subject: [PHP-WIN] Windows and Linux Hi everyone, I built a small requirement using PHP and mySQL and using Win'98 and PWS as my production server. I followed the default instructions in setting this up. After the phase was completed we copied the site and the db script on a Linux machine with Apache Web Server. However some of our mySQL code is not working. Are there any known issues and differences while porting ? I get errors like: Warning: Supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/shrunkenplanet/demo/content/index.php on line 12 line 12 has the following code: $row_array = mysql_fetch_row($rsRef); I know my connection to the db is being established. Command like $rsRef = mysql_query($Query); are working (since they occur before mysql_fetch_row() Can anybody point me in the right direction. I am at my wit end trying to figure this out. Unfortunatly I have absolutly no knowledge of Linux and Apache. I guess it as to do with the mySQL library installed or some configuration settings ? Any help will be really appreciated. TIA -Mujahid -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

« previous php.windows (#6150) next »