- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
if ($check==0)
{
$query = "SELECT id, title, news, author, date FROM news ORDER BY id DESC LIMIT 10";
}else{
$query = "SELECT id, title, news, author, date FROM news ORDER BY id LIMIT 10";
}
$result = mysql_query($query,$db);
$_count=0;
while($row=mysql_fetch_array($result))
{
$_count++;
}
$result = mysql_query($query,$db);
while($row=mysql_fetch_array($result))
{
...
успевают запостить несколько новостей за доли секунды 🙂
Сбрасывает указатель в начало.
$query = "SELECT id, title, news, author, date FROM news ORDER BY id $order LIMIT 10";
$result = mysql_query($query,$db);
$_count = mysql_num_rows($result);
while($row=mysql_fetch_array($result))
{
...
}