freelanceprogrammers.org Forum Index » PHP

View previous topic :: View next topic

Re: help me ......

songopt1 Posted: Wed Apr 20, 2005 6:34 pm

Joined: 20 Apr 2005

Posts: 2

Re: help me ......

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@...
Date: Wed, 20 Apr 2005 03:59:51 -0700 (PDT)
To: php-objects@yahoogroups.com
Subject: [php-objects] help me ......

<html><body>

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

 
<tt>
PHP Data object relational mapping generator - <a
href="http://www.meta-language.net/">http://www.meta-language.net/</a></tt>
 



 
<tt><hr width="500">
Yahoo! Groups Links 
<ul>
<li>To visit your group on the web, go to: <a
href="http://groups.yahoo.com/group/php-objects/">http://groups.yahoo.com/gr
oup/php-objects/</a> 
<li>To unsubscribe from this group, send an email to: <a
href="mailto:php-objects-unsubscribe@yahoogroups.com?subject=Unsubscribe">ph
p-objects-unsubscribe@yahoogroups.com</a> 
<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>




</body></html>

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .

amit_800 Posted: Wed Apr 20, 2005 6:57 pm

Joined: 20 Apr 2005

Posts: 3

Re: help me ......

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

sunitsinha Posted: Thu Apr 21, 2005 12:06 pm

Joined: 20 Apr 2005

Posts: 12

Re: help me ......

hi,
i have done it..
but the problem is same..

please guide me..

bye
Sunit

--- amit bansal <amit_800@...> 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@...> 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 ."> FACE=arial
> > SIZE=1> ". $sr . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>";
> > echo "<a
> > href=javascript:userdetails(`$emp_code_list`)>"
> > .$name. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ".$emp_code_list. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ". $desig . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ". $doj . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>". $sup_emp. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>". $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
> >
>
> __________________________________________________
> 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

imranforphp Posted: Thu Apr 21, 2005 12:27 pm

Joined: 21 Apr 2005

Posts: 4

Re: help me ......

just try to append @ infront of the mysql_fetch_Array() and check.... hope it
will not display u the warning.
The exact reason could not be traced
take care

Sunit Sinha <sunitsinha@...> wrote:
hi,
i have done it..
but the problem is same..

please guide me..

bye
Sunit

--- amit bansal <amit_800@...> 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@...> 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 ."> FACE=arial
> > SIZE=1> ". $sr . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>";
> > echo "<a
> > href=javascript:userdetails(`$emp_code_list`)>"
> > .$name. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ".$emp_code_list. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ". $desig . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ". $doj . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>". $sup_emp. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>". $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
> >
>
> __________________________________________________
> 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@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]

bansalakhil3... Posted: Thu Apr 21, 2005 12:30 pm

Joined: 21 Apr 2005

Posts: 9

Re: help me ......

I agreed with that , this will definitly work,
Congtates

On 4/21/05, imran rahi <imranforphp@...> wrote:
>
> just try to append @ infront of the mysql_fetch_Array() and check.... hope
> it will not display u the warning.
> The exact reason could not be traced
> take care
>
> Sunit Sinha <sunitsinha@...> wrote:
> hi,
> i have done it..
> but the problem is same..
>
> please guide me..
>
> bye
> Sunit
>
> --- amit bansal <amit_800@...> 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@...> 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 ."> > FACE=arial
> > > SIZE=1> ". $sr . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>";
> > > echo "<a
> > > href=javascript:userdetails(`$emp_code_list`)>"
> > > .$name. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ".$emp_code_list. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ". $desig . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ". $doj . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>". $sup_emp. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>". $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
> > >
> >
> > __________________________________________________
> > 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@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
> 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@yahoogroups.com<php-objects-unsubscribe@yahoogroups.com?
subject=Unsubscribe>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>

--
Akhil Bansal

[Non-text portions of this message have been removed]

ssk_quanta Posted: Thu Apr 21, 2005 12:32 pm

Joined: 21 Apr 2005

Posts: 3

Re: help me ......

hi ,

use

$row=mysql_fetch_object($result);
$name=$row->name;

santhosam
ssk
blr

--- Sunit Sinha <sunitsinha@...> wrote:
---------------------------------
hi,
i have done it..
but the problem is same..

please guide me..

bye
Sunit

--- amit bansal <amit_800@...> 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@...> 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 ."> FACE=arial
> > SIZE=1> ". $sr . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>";
> > echo "<a
> > href=javascript:userdetails(`$emp_code_list`)>"
> > .$name. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ".$emp_code_list. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ". $desig . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1> ". $doj . " </td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>". $sup_emp. "</td>";
> > echo "<td bgcolor=".$color_code ."> FACE=arial
> > SIZE=1>". $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
> >
>
> __________________________________________________
> 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@yahoogroups.com

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

bansalakhil3... Posted: Thu Apr 21, 2005 12:36 pm

Joined: 21 Apr 2005

Posts: 9

Re: help me ......

what is the difference b/w $row["name"] and $row->name

On 4/21/05, sasikumar shanmugam <ssk_quanta@...> wrote:
>
> hi ,
>
> use
>
> $row=mysql_fetch_object($result);
> $name=$row->name;
>
> santhosam
> ssk
> blr
>
>
> --- Sunit Sinha <sunitsinha@...> wrote:
> ---------------------------------
> hi,
> i have done it..
> but the problem is same..
>
> please guide me..
>
> bye
> Sunit
>
> --- amit bansal <amit_800@...> 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@...> 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 ."> > FACE=arial
> > > SIZE=1> ". $sr . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>";
> > > echo "<a
> > > href=javascript:userdetails(`$emp_code_list`)>"
> > > .$name. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ".$emp_code_list. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ". $desig . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ". $doj . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>". $sup_emp. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>". $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
> > >
> >
> > __________________________________________________
> > 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@yahoogroups.com
>
> 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@yahoogroups.com<php-objects-unsubscribe@yahoogroups.com?
subject=Unsubscribe>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>

--
Akhil Bansal

[Non-text portions of this message have been removed]

h_tere2000 Posted: Thu Apr 21, 2005 7:46 pm

Joined: 05 Apr 2005

Posts: 8

Re: help me ......

try this

$result = mysql_query("SELECT * FROM student",$db);
$num_rows = mysql_num_rows($result);

for($count=0;$count<$num_rows; $count++)
{
$row = mysql_fetch_array($result);
extract($row);
echo "<td bgcolor=".$color_code.">"
.$emp_code_list. "</td>";
}

i`m sure this will do the trick just need sql
statement added in..
btw extract function converts
$row[`username`]="ali baba"
to
$username = "ali baba"; in fact all the array in $row

good luck
--- sasikumar shanmugam <ssk_quanta@...>
wrote:

> hi ,
>
> use
>
> $row=mysql_fetch_object($result);
> $name=$row->name;
>
> santhosam
> ssk
> blr
>
>
> --- Sunit Sinha <sunitsinha@...> wrote:
> ---------------------------------
> hi,
> i have done it..
> but the problem is same..
>
> please guide me..
>
> bye
> Sunit
>
> --- amit bansal <amit_800@...> 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@...> 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 ."> > FACE=arial
> > > SIZE=1> ". $sr . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>";
> > > echo "<a
> > > href=javascript:userdetails(`$emp_code_list`)>"
> > > .$name. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ".$emp_code_list. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ". $desig . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1> ". $doj . " </td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>". $sup_emp. "</td>";
> > > echo "<td bgcolor=".$color_code ."> > FACE=arial
> > > SIZE=1>". $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
> > >
> >
> > __________________________________________________
> > 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@yahoogroups.com
>
> 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
>

__________________________________________________
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