Here is some more information. I have been experimenting with MSExcel/ODBC/Progress and this works just fine. Excel uses the same ODBC driver that PHP should be using to access the Progress database. So now I am leaning towards what appears to be a problem with PHP being able to use that driver for Progress.
How do I pass this this on to PHP? "Uttam" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > i was also having trouble with odbc/access, may be my function can work for > you too: > try this code: > > <? > $TableName = "PUB.table1"; > $Link = odbc_connect ($DBName,$User,$Password); > $Query = "SELECT * from $TableName"; > $Results = odbc_do($Link, $Query); > odbctable($Results); > > function odbctable($result) { > echo "<table border=1 cellspacing=0><tr>"; > $numfields=odbc_num_fields($result); > for ($i=1;$i<=$numfields;$i++) { > echo "<td>".odbc_field_name($result,$i)."</td>"; > } > echo "</tr>"; > while (odbc_fetch_into($result,$row)) { > echo "<tr>"; > for ($i=0;$i<$numfields;$i++) { > echo "<td>$row[$i]</td>"; > } > echo "</tr>"; > } > echo "</table>"; > } > > ?> > > regds, > -----Original Message----- > From: Douglas F. Keim [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 16:48 > To: [EMAIL PROTECTED] > Subject: Re: Rows of data all the same > > > This is an update on this problem. Direct SQL commands are working just > fine with the query, but as soon as I use the php commands it get these > results. I have tried stepping through the rows with various odbc > commands > with similar results. Now I am suspecting that the $Results are only > getting the first record in the table three times since there are three > records in the table. > > I have tried while statements, odbc_fetch_row, next ... the list goes > on. > All I have accomplished if seeing the whole of or parts of the same > record > each time. > > I just don't think the query is working in php. And if so, I don't know > how > to verify that. > > Any suggestions? > > "Douglas F. Keim" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I have this query that I performing on the database. > > > > Unfortunately, it is returning all the same information for all rows. > > > > The table has three rows of data in it > > Tbl_ID Tbl_Name Tbl_Age > > 1 Horse 21 > > 2 Cow 30 > > 3 Eagle 14 > > > > My php script looks like this. > > $TableName = "PUB.table1"; > > $Link = odbc_connect ($DBName,$User,$Password); > > $Query = "SELECT * from $TableName"; > > $Results = odbc_do($Link, $Query); > > print odbc_result_all($Results); > > > > My browser results are as follows ... > > Tbl_ID Tbl_Name Tbl_Age > > 1 Horse 21 > > 1 Horse 21 > > 1 Horse 21 > > > > > > I am not sure what I am doing wrong here. > > > > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
