hi
i am generation the list of employee of a compalny and
i am using the mysql db. when i call the list page on
browser a waring messages is generated at the top of
the page and this waring is reapeated upto the total
number of employee and below that the list is
completely fine..
the message is :
**************************************************
Warning: Unable to jump to row 0 on MySQL result index
412 in /var/www/html/hradmin/app_list.php on line ...
*************************************************
my code and query is:
$list= mysql_query("SELECT emp_code, dept, desig,
date_format(doj,'%d-%m-%Y') as doj, name, supervisor,
hod, level, status, email FROM employee order by
status desc", $db) or die ("Unable to connect
database.");
while ($row = mysql_fetch_array($list))
{
$name = $row['name'];
$emp_code_list = $row['emp_code'];
$desig = $row['desig'];
$doj= $row['doj'];
$email= $row['email'];
$emp_status=$row['status'];
$emp_supervisor=$row['supervisor'];
$emp_hod=$row['hod'];
$emp_level=$row['level'];
$i++;
echo "<tr>";
echo "<td bgcolor=".$color_code ."><FONT FACE=arial
SIZE=1> ". $sr . " </font></td>";
echo "<td bgcolor=".$color_code ."><FONT FACE=arial
SIZE=1>";
echo "<a
href=javascript:userdetails('$emp_code_list')>"
.$name. "</font></td>";
echo "<td bgcolor=".$color_code ."><FONT FACE=arial
SIZE=1> ".$emp_code_list. "</font></td>";
echo "<td bgcolor=".$color_code ."><FONT FACE=arial
SIZE=1> ". $desig . " </font></td>";
echo "<td bgcolor=".$color_code ."><FONT FACE=arial
SIZE=1> ". $doj . " </font></td>";
echo "<td bgcolor=".$color_code ."><FONT FACE=arial
SIZE=1>". $sup_emp. "</font></td>";
echo "<td bgcolor=".$color_code ."><FONT FACE=arial
SIZE=1>". $hod_name. "</font></td></tr>";
$sr++;
}
***************************************
Please help me .....
with thanks
Sunit
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
<*> To unsubscribe from this group, send an email to:
php-objects-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
