Rows of data all the same
| From: | Douglas F. Keim | Date: | Wed, 09 Oct 2002 14:32:01 +0000 |
| Subject: | Rows of data all the same | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-16286@lists.php.net to get a copy of this message | ||
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.