Limit Amount of Records Returned?

BulldogGC

Using ODBC w/ MS Access how would I say, return only 5 records from a query.

If any of you are familiar with CFM something like

thanks!

khaldryck

you can either use the limit in your query

select * from table limit 5

or depending on how you retrieve you data in PHP you can also break out of the loop after 5 rows are returned

ex :

$query="select * from table";
$res=odbc_exec($query);
$i=0;
while($row=odbc_fetch_array($res)) {
do your stuff here
if($i++==5) break;
}

i don't especially like the second method, and i'm sure there are others.

BulldogGC

	$sql = "SELECT name FROM guns ORDER BY id DESC";
	$execute = odbc_exec($db,$sql);
	$maxrows = 0;
		while(odbc_fetch_row($execute)) {
		do $name = odbc_result($execute,1);
				echo "$name<br>";}
		if($maxrows++==5) break;
		}

Doesn't seem to work?
Any suggestions?

khaldryck

$sql = "SELECT name FROM guns ORDER BY id DESC";
    $execute = odbc_exec($db,$sql);
    $maxrows = 0;
        while($row=odbc_fetch_row($execute)) {
        do $name = odbc_result($row,0);
                echo "$name<br>";}
        if($maxrows++==5) break;
        }

you forgot to assign your row
also the first result is 0 not 1
not sure as i use mysql and not odbc, though

BulldogGC

	$sql = "SELECT name FROM guns ORDER BY id DESC";
    $execute = odbc_exec($db,$sql);
    $maxrows = 0;
        while($row=odbc_fetch_row($execute)) {
        do $name = odbc_result($row,1);
                echo "$name<br>";
        if($maxrows++==5) break;
        }

Parse error: parse error, unexpected T_ECHO, expecting T_WHILE

Still no dice ... above is the error it gives off =(

khaldryck

$sql = "SELECT name FROM guns ORDER BY id DESC";
    $execute = odbc_exec($db,$sql);
    $maxrows = 0;
        while($row=odbc_fetch_row($execute)) {
        $name = odbc_result($row,1);
                echo "$name<br>";
        if($maxrows++==5) break;
        }

sorry i didn't check all your code previously.
if you're using while loop, you don't need do.

check also for your odbc_result, i think it's 0 not 1 you need.

ccgorman

Don't know if this will help but I think you may want to use the TOP command.

SELECT TOP 5 * FROM table

This will return 5 rows, you can also set a WHERE clause, so you could say WHERE unique_id>40...