freelanceprogrammers.org Forum Index » PHP

View previous topic :: View next topic

help me ......

sunitsinha Posted: Wed Apr 20, 2005 3:59 pm

Joined: 20 Apr 2005

Posts: 12

help me ......

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 ."> ". $sr . " </td>";
echo "<td bgcolor=".$color_code .">";
echo "<a
href=javascript:userdetails(`$emp_code_list`)>"
.$name. "</td>";
echo "<td bgcolor=".$color_code ."> ".$emp_code_list. "</td>";
echo "<td bgcolor=".$color_code ."> ". $desig . " </td>";
echo "<td bgcolor=".$color_code ."> ". $doj . " </td>";
echo "<td bgcolor=".$color_code .">". $sup_emp. "</td>";
echo "<td bgcolor=".$color_code .">". $hod_name. "</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

freelanceprogrammers.org Forum Index » PHP

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help