This is neither a problem with PHP nor FreeTDS. From the manual: " sybase_fetch_array() is an extended version of sybase_fetch_row(). In addition to storing the data in the numeric indices of the result array, it also stores the data in associative indices, using the field names as keys. "
Therefore each row contains duplicates of each value. Use sybase_fetch_row() instead. And, btw, this question really belongs on the php-general list. ;) - Gabriel Rose, Billy wrote: > Environment: > > Apache 2.0.35 > PHP 4.2.0RC2 > FreeTDS used in place of Sybase libraries to connect to MS SQL 2000 > RedHat Linux 7.1 > PII 233 > > Problem: > > Using foreach retrieves a duplicate of each database column. > > Code tested: > > <html> > <head> > <title>Test</title> > </head> > <body> > <? > $link = sybase_connect($dbhost,$dbuser,$dbpass) > or die("Error connecting"); > sybase_select_db($dbname) > or die("Error selecting database"); > $result = sybase_query($query) > or die("Error running query"); > print("<table border='0' width='100%' cellpadding='0' cellspacing='4'>\n"); > while ($row = sybase_fetch_array($result)) { > print("<tr>\n"); > foreach ($row as $col) { > print("<td>".$col."</td>\n"); > } > print("</tr>\n"); > } > print("</table>\n"); > sybase_free_result($result); > sybase_close($link); > ?> > </body> > </html> > > Is this a PHP issue, or a FreeTDS problem? > > Billy Rose > [EMAIL PROTECTED] > -- Gabriel Ricard [EMAIL PROTECTED] -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, visit: http://www.php.net/unsub.php