Is this :
while ($row = mysql_fetch_array($list))
The line generating the warning? If so, and I'm shooting blindly here,
could you var_dump( $list ) just to see if it's the mysql_result you're
expecting?
David Ramalho
Original Message:
-----------------
From: Sunit Sinha sunitsinha@xxxxxxxxx
Date: Wed, 20 Apr 2005 03:59:51 -0700 (PDT)
To: php-objects@xxxxxxxxxxxxxxx
Subject: help me ......
<html><body>
<tt>
hi <BR>
<BR>
i am generation the list of employee of a compalny and<BR>
i am using the mysql db. when i call the list page on<BR>
browser a waring messages is generated at the top of<BR>
the page and this waring is reapeated upto the total<BR>
number of employee and below that the list is<BR>
completely fine..<BR>
the message is :<BR>
**************************************************<BR>
Warning: Unable to jump to row 0 on MySQL result index<BR>
412 in /var/www/html/hradmin/app_list.php on line ... <BR>
<BR>
*************************************************<BR>
<BR>
my code and query is:<BR>
<BR>
$list= mysql_query("SELECT emp_code, dept, desig,<BR>
date_format(doj,'%d-%m-%Y') as doj, name, supervisor,<BR>
hod, level, status, email FROM employee order by<BR>
status desc", $db) or die ("Unable to connect<BR>
database.");<BR>
<BR>
<BR>
while ($row = mysql_fetch_array($list))<BR>
{<BR>
$name = $row['name'];<BR>
$emp_code_list = $row['emp_code'];<BR>
$desig = $row['desig'];<BR>
$doj= $row['doj'];<BR>
$email= $row['email'];<BR>
$emp_status=$row['status'];<BR>
$emp_supervisor=$row['supervisor'];<BR>
$emp_hod=$row['hod'];<BR>
$emp_level=$row['level'];<BR>
$i++;<BR>
<BR>
echo "<tr>";<BR>
echo "<td bgcolor=".$color_code ."><FONT FACE=arial<BR>
SIZE=1> ". $sr . " </font></td>";<BR>
echo "<td bgcolor=".$color_code ."><FONT FACE=arial<BR>
SIZE=1>";<BR>
echo "<a<BR>
href=javascript:userdetails('$emp_code_list')>"<BR>
.$name. "</font></td>";<BR>
echo "<td bgcolor=".$color_code ."><FONT FACE=arial<BR>
SIZE=1> ".$emp_code_list. "</font></td>";<BR>
echo "<td bgcolor=".$color_code ."><FONT FACE=arial<BR>
SIZE=1> ". $desig . " </font></td>";<BR>
echo "<td bgcolor=".$color_code ."><FONT FACE=arial<BR>
SIZE=1> ". $doj . " </font></td>";<BR>
echo "<td bgcolor=".$color_code ."><FONT FACE=arial<BR>
SIZE=1>". $sup_emp. "</font></td>";<BR>
echo "<td bgcolor=".$color_code ."><FONT FACE=arial<BR>
SIZE=1>". $hod_name. "</font></td></tr>";<BR>
$sr++;<BR>
<BR>
}<BR>
<BR>
***************************************<BR>
Please help me .....<BR>
<BR>
with thanks<BR>
Sunit<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
__________________________________________________<BR>
Do You Yahoo!?<BR>
Tired of spam? Yahoo! Mail has the best spam protection around <BR>
<a href="http://mail.yahoo.com";>http://mail.yahoo.com</a> <BR>
</tt>
<br><br>
<tt>
PHP Data object relational mapping generator - <a
href="http://www.meta-language.net/";>http://www.meta-language.net/</a></tt>
<br><br>
<!-- |**|begin egp html banner|**| -->
<br>
<tt><hr width="500">
<b>Yahoo! Groups Links</b><br>
<ul>
<li>To visit your group on the web, go to:<br><a
href="http://groups.yahoo.com/group/php-objects/";>http://groups.yahoo.com/gr
oup/php-objects/</a><br>
<li>To unsubscribe from this group, send an email to:<br><a
href="mailto:php-objects-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe";>ph
p-objects-unsubscribe@xxxxxxxxxxxxxxx</a><br>
<li>Your use of Yahoo! Groups is subject to the <a
href="http://docs.yahoo.com/info/terms/";>Yahoo! Terms of Service</a>.
</ul>
</tt>
</br>
<!-- |**|end egp html banner|**| -->
</body></html>
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.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/
