hi , use $row=mysql_fetch_object($result); $name=$row->name; santhosam ssk blr --- Sunit Sinha <sunitsinha@xxxxxxxxx> wrote: --------------------------------- hi, i have done it.. but the problem is same.. please guide me.. bye Sunit --- amit bansal <amit_800@xxxxxxxxx> wrote: > 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 > __________________________________________________ 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 the Yahoo! Terms of Service. Sasikumar S MSPL Bangalore 0 98453 15353 ________________________________________________________________________ Yahoo! India Matrimony: Find your life partner online Go to: http://yahoo.shaadi.com/india-matrimony 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/