Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

RE: [PHP-DB] Problems with PHP / Progress / ODBC From: indrek siitan (tfr <email protected>)
Date: 05/08/01

Hi,

> Progress databases prefer the odbc_prepare, odbc_execute sequence
> over the odbc_exec functions ( I don't know why )

ok, changed the code to following:

 --- 8< ---

<?
$sth=odbc_prepare($DBH,"SELECT Trkoodi,Trnimi FROM Turyhma WHERE
Trkoodi<103000");
if (odbc_execute($sth))
{
  while(odbc_fetch_row($sth))
  {
    echo "<li> " . odbc_result($sth,"Trkoodi") . " - " .
odbc_result($sth,"Trnimi");
  }
}
else
{
  echo "execute failed.";
}

 --- 8< ---

still no good. odbc_execute() is successful, but the while
odbc_fetch_row() falls into infinite loop until it reaches
the PHP script max execution time. then i'll get a pageful
of lines with "• -" (the odbc_result() call won't return
anything)

Rgds,
  Tfr

  --==< tfr <email protected> >==< http://tfr.cafe.ee/ >==< +372-50-17621 >==-- 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>