Re: how to handle exception in php
| From: | Bavithra R | Date: | Sat, 08 May 2010 11:30:43 +0000 |
| Subject: | Re: how to handle exception in php | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47149@lists.php.net to get a copy of this message | ||
hi friends...
Thanks for your suggestions..but i could not get the exact rank list
properly..
My code is as below..
$sql2="SELECT * FROM rank";
$result=mysql_query($sql2,$con);
$num=mysql_num_rows($result);
for($i=0;$i<$num;$i++)
{
$f1=mysql_result($result,$i,"regno");
$d6=mysql_result($result,$i,"total");
$d7=mysql_result($result,$i+1,"total");
$d8=mysql_result($result,$i,"rank");
if($d6==$d7)
{
$sql8="UPDATE $_POST[test] set rank='$i'+1 where total='$d6'";
mysql_query($sql8,$con);
}
else if($d6!=$d7)
{
$sql1="UPDATE $_POST[test] SET rank='$i'+1 WHERE regno='$f1'";
mysql_query($sql1,$con);
}
But if i use while loop as you people said..No such list is obtained.
Please check and tell if i could do any changes in the above code..
Also if any two students has secured the same total they has to be given the
same rank..Till now it generates the rank but in this order...1 2 3 4 7 7
7..As the last 3 students has the got same total..
any suggestion
regards
--Bavithra