Posted: Wed Oct 11, 2006 8:15 am
Your localhost is running PHP 5.xx and your server is running PHP 4.xx - have you changed your scripts to include some PHP 5 only functions?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
From a PHP5 Local server to a PHP4 Production server with different extensions loaded...manikandan wrote:After modifying i upload that file into web server. That modified page alone not working well, i mean that page displays HTML content alone,it didn't fetch the data from DataBase.
Code: Select all
$db = mysql_connect(,,) or die(mysql_error())
mysql_select_db(,$db) or die(mysql_error());
$query = '...';
$result = mysql_query($query, $db) or die (mysql_error());
if ( 0==mysql_num_rows($result) ) {
echo 'no results';
}Code: Select all
$result = mysql_query($query, $db) or die (mysql_error());
echo "\n<div>Debug: ", mysql_num_rows($result), " records found.</div>\n";Code: Select all
$sql="(Select c_colori.cod_parte as code,c_colori.descr_parte FROM c_colori INNER JOIN ordini2 ON (c_colori.cod_parte=ordini2.cod_art AND ordini2.bu='".$name."') )UNION (select c_colori.cod_parte,c_colori.descr_parte FROM c_colori INNER JOIN ordini3 ON (c_colori.cod_parte=ordini3.cod_art AND ordini3.bu='".$name."')) UNION (select c_colori.cod_parte,c_colori.descr_parte FROM c_colori INNER JOIN magazzino_transito_1 ON (c_colori.cod_parte=magazzino_transito_1.cod_art AND magazzino_transito_1.bu='".$name."') )order by code;";hm weird. complex yes but "cutting edge mysql technology"?manikandan wrote:This error handlig code reports that the server side mysql version cannot process the complex query like this(below the complex query),Code: Select all
$sql="(Select c_colori.cod_parte as code,c_colori.descr_parte FROM c_colori INNER JOIN ordini2 ON (c_colori.cod_parte=ordini2.cod_art AND ordini2.bu='".$name."') )UNION (select c_colori.cod_parte,c_colori.descr_parte FROM c_colori INNER JOIN ordini3 ON (c_colori.cod_parte=ordini3.cod_art AND ordini3.bu='".$name."')) UNION (select c_colori.cod_parte,c_colori.descr_parte FROM c_colori INNER JOIN magazzino_transito_1 ON (c_colori.cod_parte=magazzino_transito_1.cod_art AND magazzino_transito_1.bu='".$name."') )order by code;";
Code: Select all
<?php
$db = mysql_connect('localhost', '...username...', '...password...') or die(mysql_error());
echo 'server version: ', mysql_get_server_info($db);
?>UNION wasn't implemented in mysql 3.manikandan wrote:MySQL Version:
Server:
MySQL 3.23.54
and is not up-to-date for quite a while.http://dev.mysql.com/doc/refman/4.1/en/news.html wrote:D.3.6. Changes in release 3.23.54 (05 December 2002)
http://downloads.mysql.com/archives.php?p=mysql-3.23&v=3.23.54 wrote:MySQL is discontinuing support of this release on 31 July 2006 according to our support lifecycle policy announcement. MySQL Network subscribers and OEM customers will continue to be supported until 31 Dec 2006.