CODEWITHSUNDEEP
phpmysql
mathew
mathew

Reputation: 1200

HOw do I limit array to a certain number?

actually what I am trying to do is store incoming searches in a database and then display to a web page limiting to a certain number say 10 with the heading of "Recent Searches". if you LIMIT 10 in database query then It stops after 10. so thought will cut off loop but both case it stops at 10. so after that what ever searches happens it wont update it. is there any one can help me in this situation?? 

$result = mysql_query("SELECT * FROM query ORDER BY regtime DESC");
while($row = mysql_fetch_array($result))
{
  echo "<img src='bullet.gif' align='absmiddle' class='col1ab'><a class='col1ab' href=".$row['web']." >www.".$row['web']."</a><br>";
}

Upvotes: 0

Views: 803

Answers (5)

user936965
user936965

Reputation:

Why did no one come up with:

SELECT * FROM query ORDER BY regtime DESC LIMIT 0,6

Upvotes: 0

Sarfraz
Sarfraz

Reputation: 382686

Try this:

$result = mysql_query("SELECT * FROM query ORDER BY regtime DESC");

$counter = 0;
while($row = mysql_fetch_array($result))
{
  echo "<img src='bullet.gif' align='absmiddle' class='col1ab'><a class='col1ab' href=".$row['web']." >www.".$row['web']."</a><br>";

  if (++$counter === 10) break;
}

The loop increments the value of $counter variable and when it becomes 10, the break keyword exits out of the while loop there by giving you just 10 iterations.

Upvotes: 0

Jim
Jim

Reputation: 725

Not the requested answer but ...

Don't store searches. Make your data efficiently searchable.(search friendly schema,index, partitioning, more hardware)

reasons: query data is no longer real time if read from query table more space is needed for duplicate data in query table more io is required to fill the query table

use 2 queries or estimate (how critical is accuracy?(since it is stored, the number is most likely not accurate))

"SELECT * FROM query ORDER BY regtime DESC" with LIMIT(10) "SELECT count(*) FROM query..."

Upvotes: 0

ceejayoz
ceejayoz

Reputation: 180004

$count = 0;
$result = mysql_query("SELECT * FROM query ORDER BY regtime DESC");
while($count < 10 && $row = mysql_fetch_array($result))
{
  $count++;
  echo "<img src='bullet.gif' align='absmiddle' class='col1ab'><a class='col1ab' href=".$row['web']." >www.".$row['web']."</a><br>";
}

Upvotes: 4

animuson
animuson

Reputation: 54729

Limit what array? I don't see an array in your code. If you want to limit the number of echos you make, you can count a variable and then break once you reach 10, like so:

$result = mysql_query("SELECT * FROM query ORDER BY regtime DESC");
while($row = mysql_fetch_array($result))
{
  if ($i++ >= 10) break;
  echo "<img src='bullet.gif' align='absmiddle' class='col1ab'><a class='col1ab' href=".$row['web']." >www.".$row['web']."</a><br>";
}

Upvotes: 1

Related Questions