Re: [PHP-DB]how to handle exception in php
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
Re: [PHP-DB]how to handle exception in php
Dear Bavithra,
I would suggest you the following solution
$sql = SELECT x FROM y;
$rs = mysql_query ($sql)
$num = mysql_numrows($rs);
while ($i $num){
z = mysql_result($rs, $i, 'x');
$i++;
}
I hope that above solution help you.
Luiz Alberto
On Sun, 2010-05-02 at 10:56 +0530, Bavithra R wrote:
hi friends
I am doing a simple student mark details project.
for calculating rank I need to compare the total marks one by one.
To do so i use *for loop.* so atlast while reaching the end of the table it
shows the following warning.
*
Warning*: mysql_result()
[function.mysql-resulthttp://127.0.0.1/pro/function.mysql-result]:
Unable to jump to row 18 on MySQL result index on line *50*
It is because it has no next value to compare.How to use try..catch
exception handling in this.?Or any other suggestion.
Can anybody help me
--Bavithra
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB]how to handle exception in php
On 02/05/10 15:26, Bavithra R wrote:
hi friends
I am doing a simple student mark details project.
for calculating rank I need to compare the total marks one by one.
To do so i use *for loop.* so atlast while reaching the end of the table it
shows the following warning.
*
Warning*: mysql_result()
[function.mysql-resulthttp://127.0.0.1/pro/function.mysql-result]:
Unable to jump to row 18 on MySQL result index on line *50*
It is because it has no next value to compare.How to use try..catch
exception handling in this.?Or any other suggestion.
Can anybody help me
This isn't an exception, so a try catch won't work. (Exceptions are
fatal and would say something like uncaught exception ...).
This is a warning about trying to read something that doesn't exist from
mysql.
I'd do something like
$query = select blah;
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo do stuff here;
}
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
