Bug #10568: error using ODBC
| From: | hpincheira at fasa dot cl | Date: | Mon, 30 Apr 2001 22:37:36 +0000 |
| Subject: | Bug #10568: error using ODBC | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-53138@lists.php.net to get a copy of this message | ||
From: hpincheira@fasa.cl
Operating system: Win 98
PHP version: 4.0.4pl1
PHP Bug Type: ODBC related
Bug description: error using ODBC
Hello:
I am using a database called " RECITAL ". I am trying to connect myself using ODBC. When
executing the command: odbc_exec($connect, $query) I can revise the connection from the database and
indeed her ago. But then treatment of consenting to the data using any function ODBC, for example:
--------------------------------
odbc_result_all($connect, BGCOLOR = ' #AAFFAA ' border=3 width=30% bordercolordark =
' #FF0000 '");
-------------------------------
and it throws me this error:
---------------------------------
Warning: Not tuples available at this result index in programa/apache c:/archivos
group/apache/htdocs/b.html on line 7
---------------------------------
I need to know if they can help me with this.
thank you.
(the table if it exists, some fields is: nlocal,ncontr)
This is the program php:
---------------------------------------
<?php
function to () {
$connect = odbc_connect (" dig ", " root ", cir0921, " SQL_CUR_USE_ODBC
");
$query = SELECT * local FROM";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)) {
$id=odbc_result($result,1);
$pass=odbc_result($result,2);
echo id:$id,pass:$pass
";
}
odbc_close_all($connect);
return true;
} / / a
?>
<?php
echo"Lines Before";
$bb = a();
echo " Lines Later";
?>
---------------------------------------
--
Edit Bug report at: http://bugs.php.net/?id=10568&edit=1