[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-general-es
Subject:    Re: [PHP-ES] mysql_fetch_array
From:       Juan Francisco Giordana <juangiordana () gmail ! com>
Date:       2005-03-31 21:10:23
Message-ID: 424C673F.4010802 () gmail ! com
[Download RAW message or body]

xfedex wrote:
> $sql = 'SELECT something FROM somewhere WHERE active = 1';
> $sql_r = mysql_query($sql);
> 
> for ($i = 1; $i <= 4; $i++) {
>    while ($diag = mysql_fetch_array($sql_r)) {
>        echo $diag['something'];
>    }
> }
> 
> Porque el echo solo funciona para la primera vuelta del for y en las 3
> restantes nada?
> 
> Saludos,
> pancarne.
> 



$sql = 'SELECT something FROM somewhere WHERE active = 1';
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result)){
	do {
		echo $row['something'];
		if (++$i == 4){
			break;
		}
	}while ($row = mysql_fetch_array($result));
}

Probá depurar con eso.
Saludos.
-- 
Juan Francisco Giordana
Homepage: http://www.juangiordana.com.ar
Linux registered user 294733

-- 
PHP Spanish Localization Talk Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]