snake_eyes
May 14th, 2009, 09:11 PM
Hello,
I just prepared the server installed odbc, I configured the the required files as well , and here is the result:
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from table;
now I made some small php code:
$conn = odbc_connect("DSN","","");
$select = "SELECT * FROM TABLE";
$result = odbc_exec($conn, $select);
while ($row = odbc_fetch_array($result))
{
$rowid = $row['name1'];
$pwd = $row['password'];
}
echo "Row id :".$rowid;
echo "password : ".$pwd;
now I'm facing a problem with I browse the file it download and ask me to save or open it, although the other projects with php and mysql are working fine.
Any idea gentleman?
Cheers,
I just prepared the server installed odbc, I configured the the required files as well , and here is the result:
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from table;
now I made some small php code:
$conn = odbc_connect("DSN","","");
$select = "SELECT * FROM TABLE";
$result = odbc_exec($conn, $select);
while ($row = odbc_fetch_array($result))
{
$rowid = $row['name1'];
$pwd = $row['password'];
}
echo "Row id :".$rowid;
echo "password : ".$pwd;
now I'm facing a problem with I browse the file it download and ask me to save or open it, although the other projects with php and mysql are working fine.
Any idea gentleman?
Cheers,