Mysql help

[pullez]

Hi to everyone:
I´ve started to populate mysql and when retrieving the results form the DB, everything works fine, except that I cannot get the very first row array and when setting the query LIMIT to 0,3 it retrieves only 1 row starting from the second one.
Thanks a lot in advance,
Jorge Alavarez

[crusty_php]

Are you using a DO..WHILE loop? If so change it to a WHILE loop.

[pullez]

Thanks:
Actually I´m using a while loop:
$i=0;
while($i < $row=mysql_fetch_array($results)){

bla
}

[crusty_php]

Try without the $i bit

while($row=mysql_fetch_array($results)){
echo $row[your_column_name]."<br>";
}

[Anon]

I suggest this one (Te sugiero este, coleguilla)

<?

$query = "SELECT campo FROM tabla";
$hacer = mysql_query($query,$ConexionActiva);

$filas = mysql_num_rows($hacer);

for($i=0;$i<$filas;$i++){

$resultado = mysql_result($hacer,$i,"campo");
echo "Resultado numero $i ---->".$resultado;

}

?>

:-)

fLIPIS

[pullez]

Thanks Martin,gracias Flips:
I will try both options, though I guess the one submitted by Flips will do the job, since I´ve alredy tried the ones submited by
Martin.
Thanks a lot again,
Saludos Jorge

[pullez]

Hi:
After making a few arrangements based on the code submitted by Flipis:
(I´m using a class to conect and query)
$results=$db->query($query);
$rows=mysql_num_rows($results);
$i=0;
for($i=0;$i<=$rows;$i++){
$row_results=mysql_fetch_array($results);
print $row_results[bla];
}
Thanks to Flipis(gracias) and Martin.
Hapy coding,
Jorge