Re: [GENERAL] Never ending (for) loop
От | Dan Wilson |
---|---|
Тема | Re: [GENERAL] Never ending (for) loop |
Дата | |
Msg-id | 002f01bee91d$d71a48e0$6fc7fea9@dwilson обсуждение исходный текст |
Ответ на | Never ending (for) loop ("Blks" <blake_star@email.msn.com>) |
Список | pgsql-general |
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 > > > >
В списке pgsql-general по дате отправления: