Re: [PHP-DB] PHP - MSSQL - LINUX

2004-03-17 Thread Santhosh Kumar
Hi Madhu, I am speaking about MSSQL not MySQL . Is it possible can i get for MSSQL.so from MYSQL Installation. Thanks and Regards, Santhosh Kumar.M - Original Message - From: Madhu Manjari To: [EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 2:27 PM Subject: Re:

[PHP-DB] RE: File Upload

2004-03-17 Thread Brock Jimmy D Contr DODHSR5
These are not errors...they are warnings...which is why it opens the file. Check the permissions on this file so the account that your web server uses has read/write permissions. On my server it is 'www'. Once you fix this warning the other two warnings should go away as well. Hope this Helps,

Re: [PHP-DB] PHP - MSSQL - LINUX

2004-03-17 Thread Adam Voigt
No, if you are attempting to run PHP under Windows, you want the MSSQL DLL File, if you are attempting to run PHP under Linux or Unix, you want to install FreeTDS from www.freetds.org On Wed, 2004-03-17 at 05:17, Santhosh Kumar wrote: Hi Madhu, I am speaking about MSSQL not MySQL . Is

RE: [PHP-DB] PHP - MSSQL - LINUX

2004-03-17 Thread Brock Jimmy D Contr DODHSR5
Open your php.ini file and uncomment the line: extension=php_mssql.dll Happy coding, Jimmy Brock -Original Message- From: Santhosh Kumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 5:17 AM To: PHP DB; [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP - MSSQL - LINUX Hi

Re: [PHP-DB] PHP - MSSQL - LINUX

2004-03-17 Thread Robert Twitty
You will need to install and configure the FreeTDS library. Another alternative is to use ODBTP, which is available at http://odbtp.sourceforge.net. It is much easier to install and configure than FreeTDS, and supports all of the mssql_* functions. However, ODBTP requires a WIn32 service to be

[PHP-DB] Mssql - Invalid Column Name

2004-03-17 Thread Henrik Hornemann
Hi, I hope someone can help me on this one. The following script: ?php include(../includes/include.php); $connect=new db_open(dnlbweb); foreach($_POST as $key = $val) { $$key=$val; } $res=mssql_query(SELECT Titel FROM indeks join indholdstyper on

[PHP-DB] SQL Server Query Failed

2004-03-17 Thread david
Hello there! I have just about driven myself crazy with an odd intermittent problem. I have an intranet site, a good size one at that, on a Windows 2000 Server, running Apache, connecting to another Windows 2000 Server running SQL Server 2000. It all works just peachy, and life is good. But

Re: [PHP-DB] SQL Server Query Failed

2004-03-17 Thread Bruno Ferreira
david wrote: Hello there! I have just about driven myself crazy with an odd intermittent problem. [snip] I'd first start by turning on all logging I could in the SQL server so that I could see what's happening straight from the horse's mouth... Bruno Ferreira --- [This E-mail scanned

Re: [PHP-DB] MySql query

2004-03-17 Thread Bruno Ferreira
Matt Matijevich wrote: This is probably a question for for a mysql list but I figured someone out here knows the answer. [snip] SELECT * FROM sometable WHERE 1 SELECT * FROM sometable Just that :) (do I hear you slapping your forehead? :) Bruno Ferreira. --- [This E-mail scanned for viruses

Re: [PHP-DB] SQL Server Query Failed

2004-03-17 Thread Robert Twitty
What type of field is PhaseFK? -- bob On Wed, 17 Mar 2004, david wrote: Hello there! I have just about driven myself crazy with an odd intermittent problem. I have an intranet site, a good size one at that, on a Windows 2000 Server, running Apache, connecting to another Windows 2000

Re: [PHP-DB] MySql query

2004-03-17 Thread Matt Matijevich
snip SELECT * FROM sometable Just that :) (do I hear you slapping your forehead? :) Bruno Ferreira. /snip Thanks for the answers guys. My problem was I am a mysql novice and there was a bunch of existing queries that use the WHERE 1 syntax. -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] MySql query

2004-03-17 Thread Adam Voigt
Yes, where evaluates to true. On Wed, 2004-03-17 at 12:03, Matt Matijevich wrote: This is probably a question for for a mysql list but I figured someone out here knows the answer. I am working with an existing mysql application and there is a bunch of queries that are formatted something

[PHP-DB] Re: SQL Server Query Failed

2004-03-17 Thread david
Bob: Is this case, PhaseFK is an integer. However, it will fail on character fields as well. Thanks! david Robert Twitty [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What type of field is PhaseFK? -- bob On Wed, 17 Mar 2004, david wrote: Hello there! I have just about

Re: [PHP-DB] Re: SQL Server Query Failed

2004-03-17 Thread Robert Twitty
Hi David There does not appear to be any reason why you are having problems. Try using the odbtp/mssql hybrid extension at http://odbtp.sourceforge.net. It uses Microsoft's ODBC driver for SQL Server. The mssql extension on Windows uses DB-Library, which Microsoft stop supporting after SQL Server

RE: [PHP-DB] MySql query

2004-03-17 Thread Ryan Jameson (USA)
One reason that my queries will look like what you described is that later I append more conditions. The where 1 allows me to tack them all on with AND or OR instead of having to put the where on later and decide things like if I need to put AND or OR or WHERE or whatever... The WHERE 1 keeps it

[PHP-DB] An old dog, with a new trick..

2004-03-17 Thread Felipe Eduardo Ortiz López
Bueno, héme aquí, un perro viejo tratando de aprender nuevos trucos. Comienzo a desarrollar en PHP, con la idea de conectar bases de datos MySQL y Firebird a las aplicaciones. ¿Me podrían orientar de por dónde comenzar, libros, sitios, algo así? Les estaré muy agradecido, y disculpen si comienzo a