TalkPHP - View Single Post

Alan @ CIT · 01-15-2008, 03:45 PM

Ahh, the joys of debugging :) My first steps in this situation would be to do some basic checks to make sure the queries are running correctly.

For example, try putting:

PHP Code:


			
var_dump($mas);

under your first mysql_fetch_array() to see if your query is actually getting any results. If that works ok, put an " or die(mysql_error());" statement after your second mysql_query() ($web2) to see if that produces any errors. If that's all ok, then the next step would be to remove the while() loop and replace it with:

PHP Code:


			
$mas2 = mysql_fetch_array($res2);
var_dump($mas2);

This would tell you if that array contains anything.

Performing these debugging steps should give you a clue as to where the problem lies

Alan.

01-15-2008, 03:45 PM	#2 (permalink)
Alan @ CIT Member of the Month The Frequenter Join Date: Apr 2005 Location: South UK Posts: 483 Thanks: 51	Ahh, the joys of debugging :) My first steps in this situation would be to do some basic checks to make sure the queries are running correctly. For example, try putting: PHP Code: `var_dump($mas);` under your first mysql_fetch_array() to see if your query is actually getting any results. If that works ok, put an " or die(mysql_error());" statement after your second mysql_query() ($web2) to see if that produces any errors. If that's all ok, then the next step would be to remove the while() loop and replace it with: PHP Code: `$mas2 = mysql_fetch_array($res2); var_dump($mas2);` This would tell you if that array contains anything. Performing these debugging steps should give you a clue as to where the problem lies Alan.