Thread: Never ending (for) loop

I wanted to thank everyone who helped me witht he postgesql limit query. I
used the examples you fella's gave and they worked great. Thanks again.

How would I quite the for loop however? If I have only 103 rows in a table,
how do I get the for loop to stop cycling through? any suggestions are
greatly appreciated.

<SCRIPT language="PHP">

if (!isset($iStart)) {
    $iStart = 0;
}
if (!isset($iEnd)) {
    $iEnd = $iStart + 10;
}

$conn = pg_Connect("", "", "", "", "contact_list");
if (!$conn) {
  echo "An error occurred.\n";
  exit;
}

$result = pg_Exec($conn, "SELECT * FROM contact_list");
if (!$result) {
    echo "An error occurred.\n";
    exit;
}

for ($iWalk = $iStart; $iWalk < $iEnd; $iWalk++) {
    $resArray = pg_fetch_array($result, $iWalk);
    echo "<TR>
            <TD>
            $resArray[2]
            </TD>
            <TD>
            $resArray[3]
            </TD>
            <TD>
            $resArray[4]
            </TD>
            <TD>
            $resArray[6]
            </TD>
            <TD>
            $resArray[1]
            </TD>
            <TD>
            $resArray[0]
            </TD>
            <TD>
            <center>
            $resArray[8]
            </center>
            </TD>
        </TR>
        ";
}

echo "<a href=\"$PHP_SELF?iStart=$iEnd\">Next 10</a>";

pg_FreeResult($result);
pg_Close($conn);
</script>

Thank You,
Blake S

If you are using the code below.  It should stop at $iEnd.  If it's the
first time through, it would stop at 10.

-Dan


> I wanted to thank everyone who helped me witht he postgesql limit query. I
> used the examples you fella's gave and they worked great. Thanks again.
>
> How would I quite the for loop however? If I have only 103 rows in a
table,
> how do I get the for loop to stop cycling through? any suggestions are
> greatly appreciated.
>
> <SCRIPT language="PHP">
>
> if (!isset($iStart)) {
>     $iStart = 0;
> }
> if (!isset($iEnd)) {
>     $iEnd = $iStart + 10;
> }
>
> $conn = pg_Connect("", "", "", "", "contact_list");
> if (!$conn) {
>   echo "An error occurred.\n";
>   exit;
> }
>
> $result = pg_Exec($conn, "SELECT * FROM contact_list");
> if (!$result) {
>     echo "An error occurred.\n";
>     exit;
> }
>
> for ($iWalk = $iStart; $iWalk < $iEnd; $iWalk++) {
>     $resArray = pg_fetch_array($result, $iWalk);
>     echo "<TR>
>             <TD>
>             $resArray[2]
>             </TD>
>             <TD>
>             $resArray[3]
>             </TD>
>             <TD>
>             $resArray[4]
>             </TD>
>             <TD>
>             $resArray[6]
>             </TD>
>             <TD>
>             $resArray[1]
>             </TD>
>             <TD>
>             $resArray[0]
>             </TD>
>             <TD>
>             <center>
>             $resArray[8]
>             </center>
>             </TD>
>         </TR>
>         ";
> }
>
> echo "<a href=\"$PHP_SELF?iStart=$iEnd\">Next 10</a>";
>
> pg_FreeResult($result);
> pg_Close($conn);
> </script>
>
> Thank You,
> Blake S
>
>
>
>