Stopping database search

[matty84]

Hi,

i was wondering if is was possible to terminate a php command when it reaches a certain number. Basically I am searching an access database over odbc and I want to limit the results to 200. I have a count going on in php and i was wondering if there was a way to tell php to stop pulling in results when the count reaches 200?

Any ideas?

matt

[fert]

[code]
while(1)
{
if($count<200)
{
/*do stuff*/
...
}
else
{
break;
}
}
[/code]
or
[code]
while($count<200)
{
/*do stuff*/
...
$count++;
}
[/code]

[Psycho]

If you are pulling the data in from a database it is more efficient to limit the data through the query. The operator to restrict the number of records returned in MySQL is "LIMIT". Perhaps there is a similar operator for your situation?