Hello.
Is it possible to mysql_fetch_array()
in for()
?
Perhaps something like this?
$sql=mysql_fetch_array(mysql_query("SELECT * FROM `tor`")); for($i=0; $i<11; $i++){ echo $sql[$i]['name']; }
<? //Вариант 1 $res = mysql_query("SELECT * FROM tor"); $nr = mysql_num_rows($result); //Лишний запрос, которого нет в вар. №2 for($i=0; $i<$nr; $i++){ $sql = mysql_fetch_array($res); echo $sql['name']; } //Вариант 2 $res = mysql_query("SELECT * FROM tor"); while ($sql = mysql_fetch_array($res)) { echo $sql['name']; }; ?>
Read about mysql_fetch_array () here . It is better to use while.
"SELECT * FROM tor
LIMIT 11"?
Source: https://ru.stackoverflow.com/questions/222053/
All Articles