Display records problem after upgrading php and mysql
Posted: Tue Jul 28, 2009 3:55 am
Hi,
I recently upgraded from
PHP Version 5.0.4
mySQL version: 4.1.14
to
PHP Version 5.1.6
mySQL version: 5.0.22
and fully functional scripts are behaving strange. One of the issues is that the php script stop dispalying more than one record.
$sqlqtext ="SELECT tmi.ServerID,tmi.IPAddress,tmi.MacID,tmi.Hostname,trs.InventHwInfo, trs.InventSwInfo, trs.InventSyInfo, trs.InventNwInfo, trs.DbHwInfo, trs.DbSwInfo, trs.DbSyInfo, trs.DbNwInfo FROM tblRepStatus trs,tblMasterInfo tmi where tmi.ServerID=trs.ServerID ";
$result1=mysql_db_query('IDT_Schema',$sqlqtext);
there is no fatal error of any kind but the script is displaying only one record.It is not displaying more than one record.
i have tried with mysql_query. Even this is not working.
could any one please help where the error is
I recently upgraded from
PHP Version 5.0.4
mySQL version: 4.1.14
to
PHP Version 5.1.6
mySQL version: 5.0.22
and fully functional scripts are behaving strange. One of the issues is that the php script stop dispalying more than one record.
$sqlqtext ="SELECT tmi.ServerID,tmi.IPAddress,tmi.MacID,tmi.Hostname,trs.InventHwInfo, trs.InventSwInfo, trs.InventSyInfo, trs.InventNwInfo, trs.DbHwInfo, trs.DbSwInfo, trs.DbSyInfo, trs.DbNwInfo FROM tblRepStatus trs,tblMasterInfo tmi where tmi.ServerID=trs.ServerID ";
$result1=mysql_db_query('IDT_Schema',$sqlqtext);
there is no fatal error of any kind but the script is displaying only one record.It is not displaying more than one record.
i have tried with mysql_query. Even this is not working.
could any one please help where the error is