RE: [PHP-DB] sybase with php4.1 and apache 13.20 problem

2002-01-08 Thread Richard Hillström (GIS)
So if I understand you correct you can call Sybase from php on commandline but not via apache? You should compile --with-sybase-ct but that is probably not causing your problem. Sounds strange, never had that problem, if it worked on cli it worked in Apache. What errormessage are you getting

[PHP-DB] php-apache-sybase install problems

2001-12-27 Thread Richard Hillström (GIS)
Maybe wrong mailing-list, but anyway, here it goes.. Trying to install Apache 1.3.22, PHP 4.0.6 and Sybase 11.0.3 on a Mandrake 8.1 box. Sybase installs fine in /opt/sybase. Apache install fine with ./configure --prefix=/usr/local/apache --enable-module=so make make install

RE: [PHP-DB] Converting MySOL query results into form elements.

2001-11-29 Thread Richard Hillström (GIS)
I solved it like this: echo SELECT NAME='databasename'; while($row = sybase_fetch_array($dbresult)) { $r0 = $row[0]; echo OPTION VALUE='$r0'$r0/OPTION; } echo /SELECTBR; //Richard -Original Message- From: Mark C. Farrington

RE: [PHP-DB] MS SQL Server support

2001-11-19 Thread Richard Hillström (GIS)
You need to recompile PHP with --enable-mssql=path/to/some/files or something like that as php does not come with support for mssql default. Read the INSTALL file that came with the sources or run, in the php source directory, ./configure -help for all the switches. //Richard

RE: [PHP-DB] Why use MySQL with PHP

2001-11-15 Thread Richard Hillström (GIS)
Personally I prefer Sybase on Linux, version 11_0_3 is free for production use and easy to install. Sybase 11_0_3 is still a very powerful DBMS although a bit dated by now, Sybase just released version 12.5. Why everyone is using MySQL I don't know, could it be that mod_php is compiled with

[PHP-DB] Sql with Sybase variables @@

2001-11-01 Thread Richard Hillström (GIS)
Hi, Is the following possible: $conn = sybase_connect(SERVER,login,passwd); $sql = select @@version; $result = sybase_query($sql,$conn); while($row = sybase_query($result)) { $r = $row[0]; echo $r; } I tried but get a strange error message that I dont understand, what would be