How did you do loop? Did you do something like this:
$result = mssql_query($query);
while (@line = mssql_fetch_row($result)) {
print "$line[0], @line[1], @line[3]\n";
}
> -----Original Message-----
> From: Douglas F. Keim [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 10, 2002 1:18 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] 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
