RE: [PHP] global variable declaration

[snip] for($j=0;$j<5;$j++): $result=mysql_query("select * from user where SponsorID='$id[$j]' "); endfor; in above code when i print mysql_num_rows($result) inside for loop its output is 5.when i print outside the for loop its o/p is 0.I searched weberdev.com website and declared $result as global.but same output 0.i want $result variable to be available outsibe the forloop and all other part of my code.i am looking forward suggestions from ur side. [/snip] You are running the query 5 times, to the mysql_num_rows($result) value will be different each time through the for loop. Try this and you'll see.... for($j=0;$j<5;$j++): $result=mysql_query("select * from user where SponsorID='$id[$j]' "); echo $j . "&nbsp;&nbsp;&nbsp;" . mysql_num_rows($result) . "<br />\n"; endfor; The output will be 0 some number of rows 1 some number of rows 2 some number of rows 3 some number of rows 4 some number of rows My bet is that the last row will have 0 rows