[RESOLVED] db call is causing page to be blank

schwim

Hi there everyone,

I've got a page that pulls the data from the config table, and allows you to edit it inside a form. It uses the following db call:

				$query = "SELECT contact_email,notify,ver_check,use_highlight,block_width,block_scroll,block_showtitle,block_showdate,block_showauth,block_showauthweb,block_titlecount,block_textcount,main_showtitle,main_showdate,main_showauth,main_showauthweb FROM ".$prefix."config";

			$result = mysql_query ($query);
			while ($row = mysql_fetch_assoc ($result)) {
			/* display testimonials in a simple table */

This works dandy on PHP 4.4.4 and MySQL 4.1.21. However on PHP 4.2.2 and MySQL 3.23, everything inside the action is blank. Not a single thing get printed.

This happens anywhere I use this db connect.

If I remove:

while ($row = mysql_fetch_assoc ($result)) {

and the companion end curly bracket, then the page loads fine.

Is there something with that command that will not work with older php installs? If so, what would I use in it's stead?

If you think the problem lies outside of the line, you can view the whole of the case here.

Any help would be greatly appreciated.

thanks,
json

schwim

I got it, I think.

After careful consideration and a cup of coffee, I decided it would be prudent to populate the table.

thanks,
json