hi,
Insted of this :-
while ($row = mysql_fetch_array($list))
try this
while ($row = mysql_fetch_array($list,MYSQL_NUM))
hope it while solve your problem....
Bye
Amit.
--- Sunit Sinha <sunitsinha@xxxxxxxxx> wrote:
> 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
>
__________________________________________________
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/
