Page 1 of 1

Display records problem after upgrading php and mysql

Posted: Tue Jul 28, 2009 3:55 am
by kuday
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

Re: Display records problem after upgrading php and mysql

Posted: Fri Jul 31, 2009 4:56 am
by jaoudestudios
You need to post more code. i.e. the loop that shows all the results