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
Display records problem after upgrading php and mysql
Moderator: General Moderators
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Display records problem after upgrading php and mysql
You need to post more code. i.e. the loop that shows all the results