Problem with Mssql_Fetch_array

tdevlin

$sql = @mssql_connect($myServer, $myUser, $myPass) 
		 	 or die("Couldn't connect to SQL Server on $myServer"); 

		 $query = "SELECT * FROM MasterAccounts"; 

		 $result = mssql_query($query);
		 $num = mssql_num_rows($result);
		 while($row = mssql_fetch_array($result)) 
		  {
			echo "$num<br />";
				echo "$row[FirstName]";
				echo "&nbsp;";
				echo "$row[LastName]";
			}

In the above code, the Table it is pulling (MasterAccounts) has 173 records. However for some odd reason that I do not understand it only pulls one record from the middle of the list. Instead of displaying every record. Am I doing something wrong? Could someone point me in the right direction? I have also tried using a while loop inside and a for loop, each with no success. Always the same record displayed and always just 1.

As always Thanks for the help,
Tony Devlin

mystrymaster

Not going to solve your problem but why this :

$num = mssql_num_rows($result);

tdevlin

For testing, I wanted to see how many records it was finding. Unfortunately it was only finding 1 record, even though there are 173 in the table. In essence it means absolutely nothing to the code or problem.

I usually work with MySQL and with that, my query above would list all of the records it found in the while statement, But MsSQL is new to me and for some reason it does not wish to return all of the records.

Thanks for the help,
Tony Devlin

maganv0x

you also seem to be missing a

mssql_select_db(database, $sql) or DIE("Couldn't select database");

tdevlin

Thank maganv0x,

The Select DB was the problem. I pop'd that in and it worked like a charm. I kinda feel dumb now.. But thanks!!

Sorry to have wasted everyone's time and Thanks to everyone who responded with help.

Tony Devlin

maganv0x

The Select DB was the problem. I pop'd that in and it worked like a charm. I kinda feel dumb now.. But thanks!!

We all overlook the simplist of things at times, don't feel bad. Just glad it fixed you up so you can get on with your script.