On Thu, 12 Aug 2004 10:04:00 -0700
[EMAIL PROTECTED] (Justin Patrin) wrote:
> On Thu, 12 Aug 2004 09:20:44 -0400, Deepak Dhake
> <[EMAIL PROTECTED]> wrote:
> > $query4 = mysql_query("SELECT result FROM TBL_result WHERE survey_no=2";
> > while($row2 = mysql_fetch_array($query4)) {
> > //print array
> > }
> >
> > this will print whole array. i just want to print a row at a time and it should be
> > in the loop because i am printing other things as well. can you tell me how to
> > print a row at a time. actually as i explained earlier, i am able to print a row
> > at a time but when it becomes i=1 and starts outer loop for the second time it
> > just printing the same values. any suggestion?
> >
>
> I think you're getting your terminology mixed up. $row2 is an array
> which corresponds to a row in the database. Yes, this will print all
> of the returned records, but I can think off very fe wtimes where you
> don't want to do that.
>
> This loop *is* what you want. Tell us what you're trying to do and
> we'll try to help.
>
$query4 = mysql_query("SELECT result FROM TBL_result WHERE survey_no=2";
$row2 = mysql_result ( $query4, 0 );
or
$i = 0;
while ( $row2 = mysql_result ( $query4, $i++ ) ) {
echo $row2;
}
Looking for this?
- Hannes
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
