[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 . " " . 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
