Display records problem after upgrading php and mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
kuday
Forum Newbie
Posts: 2
Joined: Tue Jul 21, 2009 12:18 am

Display records problem after upgrading php and mysql

Post 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
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Display records problem after upgrading php and mysql

Post by jaoudestudios »

You need to post more code. i.e. the loop that shows all the results
Post Reply