ID: 10568
User Update by: [EMAIL PROTECTED]
Old-Status: Feedback
Status: Open
Bug Type: ODBC related
Description: error using ODBC
(I’am using a traductor English/Spanish)
I use the software “Microsoft Query” for test the DNS connection and it worked very
well, but when I try to enter through php it throws me the mentioned error and not you
that it is.
This is a script:
<?php
function a() {
$connect = odbc_connect (“ dig “, “ root “, cir0921, “ SQL_CUR_USE_ODBC “);
$query = SELECT * FROM local”;
$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”;
?>
Previous Comments:
---------------------------------------------------------------------------
[2001-05-01 09:59:18] [EMAIL PROTECTED]
i'm not sure i understand the error you're receiving. can you please give a sample
script that creates the error?
also, are you sure your SELECT statement works properly?
---------------------------------------------------------------------------
[2001-04-30 18:37:36] [EMAIL PROTECTED]
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";
?>
---------------------------------------
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=10568
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
