Bizzare PHP + sqlserver problem
Posted: Thu Dec 18, 2003 4:05 pm
Hi I'm having a problem with a query and am hoping y'all can point me in the right direction
here is the basic code
the table "intenetConnections" has only 2 columns right now, and this code works as expected.
One of the engineers is testing a replication tool that adds a third column at the end of the table for a tracking ID.... when he adds this column my query no loger works. anyone have any ideas why this additional column would break this simple query?
here is the basic code
Code: Select all
$query = "SELECT * FROM InternetConnections";
$res = mssql_query($query, $dblink);
while (($row = mssql_fetch_row($res)) !== FALSE)
{
$interVal = '';
if ($user_internetConnection == $rowї0]) $interVal = ' selected';
echo "<OPTION VALUE="" . $rowї0] . """ . $interVal . ">" . $rowї1] . "</OPTION>\n";
}One of the engineers is testing a replication tool that adds a third column at the end of the table for a tracking ID.... when he adds this column my query no loger works. anyone have any ideas why this additional column would break this simple query?