CodingForums.com - View Single Post

Fou-Lu · 12-05-2012, 05:42 PM

If the page goes white, then that's typically a syntactical error. You can check your logs or enable error reporting with

PHP Code:


			
ini_set('display_errors', 1);
error_reporting(E_ALL);

You can poll for the result count as well:

PHP Code:


			
printf('There are %d records returned.', sqlsrv_num_rows($_rs));

Before that while loop. That needs to have at least one record. If it shows 0 (and no error), that indicates that your query simply has no matching results.

The semi-colon must not be on the while loop. Since the property of it takes the last resultant, that makes the returned fetch to become null (or false). Therefore it will never enter the conditional block to assign the variables individually.

12-05-2012, 05:42 PM	PM User \| #17
Fou-Lu God Emperor Join Date: Sep 2002 Location: Saskatoon, Saskatchewan Posts: 15,662 Thanks: 4 Thanked 2,452 Times in 2,421 Posts	If the page goes white, then that's typically a syntactical error. You can check your logs or enable error reporting with PHP Code: `ini_set('display_errors', 1); error_reporting(E_ALL);` You can poll for the result count as well: PHP Code: `printf('There are %d records returned.', sqlsrv_num_rows($_rs));` Before that while loop. That needs to have at least one record. If it shows 0 (and no error), that indicates that your query simply has no matching results. The semi-colon must not be on the while loop. Since the property of it takes the last resultant, that makes the returned fetch to become null (or false). Therefore it will never enter the conditional block to assign the variables individually.