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@xxxxxxxxxxx>
wrote:
> 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
>
__________________________________________________
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/
