Re: [PHP-DB] Help Needed

2002-12-26 Thread adi setiawan
-- pada 2002-12-26, 14:36:00 [EMAIL PROTECTED] menulis: -- Hi. I juz installed a RedHat 8.0 on my machine. But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20.. It's preety weird.. coz there's nothing shown up in the browser when I run phpinfo(); or even a simple 'helloworld'

[PHP-DB] php/mysql

2002-12-26 Thread Martin S
I don't know where the error lays, in php, mysql or red hat 8. But, I can't get my databased php-apps to work. I am trying to run: apache_1.3.27 php-4.2.3 mysql-3.23.53 redhat 8.0 What happens is that apache and php work nicely, but my apps cannot connect to mysql. In IRM I get can not connect

RE: [PHP-DB] Help Needed

2002-12-26 Thread dufronte
Everything's perfect.. except my browser keep blank when I run my php files... --www.kapsul.org-- DuFronte -Original Message- From: adi setiawan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 5:00 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Help Needed -- pada

Re: [PHP-DB] Help Needed

2002-12-26 Thread 1LT John W. Holmes
Everything's perfect.. except my browser keep blank when I run my php files... No, obviously it's not perfect because it's not working at all. Your page is blank because ? phpinfo() ? will be evaluated as an unknown HTML tag and come out blank. Find another tutorial that discusses how to set

Re: [PHP-DB] php/mysql

2002-12-26 Thread 1LT John W. Holmes
I don't know where the error lays, in php, mysql or red hat 8. But, I can't get my databased php-apps to work. I am trying to run: apache_1.3.27 php-4.2.3 mysql-3.23.53 redhat 8.0 What happens is that apache and php work nicely, but my apps cannot connect to mysql. In IRM I get can not

RE: [PHP-DB] How to solve T_STRING error?

2002-12-26 Thread Josh Johnson
I'd have to see all of your code, but I'm guessing you've left open a paren or a quotation mark, or a ?php ? block or forgot a semi-colon...probably in a file included before this code is called. Also, you may want to look into how PHP handles null values (I'm pretty sure they evaluate to false,

Re: [PHP-DB] php/mysql

2002-12-26 Thread Mark
I don't use RedHat, but I've heard (possibly here) that the RH PHP RPM does not *properly* install MySQL support by default and that there's something like php_mysql.rpm (or something similar) that needs to be installed as well? Does any of that sound familiar to anyone? Have I qualified that

Re: [PHP-DB] php/mysql

2002-12-26 Thread Martin S
1lt John W. Holmes wrote: I don't know where the error lays, in php, mysql or red hat 8. But, I can't get my databased php-apps to work. I am trying to run: apache_1.3.27 php-4.2.3 mysql-3.23.53 redhat 8.0 What happens is that apache and php work nicely, but my apps cannot connect to

RE: [PHP-DB] How to solve T_STRING error?

2002-12-26 Thread Martin S
Josh Johnson wrote: I'd have to see all of your code, but I'm guessing you've left open a paren or a quotation mark, or a ?php ? block or forgot a semi-colon...probably in a file included before this code is called. Also, you may want to look into how PHP handles null values (I'm pretty

Re: [PHP-DB] php/mysql

2002-12-26 Thread Martin S
Mark wrote: I don't use RedHat, but I've heard (possibly here) that the RH PHP RPM does not properly install MySQL support by default and that there's something like php_mysql.rpm (or something similar) that needs to be installed as well? Does any of that sound familiar to anyone? I've

Re: [PHP-DB] php/mysql

2002-12-26 Thread 1LT John W. Holmes
I don't use RedHat, but I've heard (possibly here) that the RH PHP RPM does not properly install MySQL support by default and that there's something like php_mysql.rpm (or something similar) that needs to be installed as well? Does any of that sound familiar to anyone? I've heard

Re: [PHP-DB] php/mysql

2002-12-26 Thread 1LT John W. Holmes
I don't know where the error lays, in php, mysql or red hat 8. But, I can't get my databased php-apps to work. I am trying to run: apache_1.3.27 php-4.2.3 mysql-3.23.53 redhat 8.0 What happens is that apache and php work nicely, but my apps cannot connect to mysql. In IRM I

[PHP-DB] php/sybase

2002-12-26 Thread Lancelot Hack
any short functions to just test the connectivity and config between php and sybase? becoz i just want to know if i compile php in the right way i just tested my apache works with php perfectly by making just several lines of html and php calling phpinfo() is there any call like this one so that

Re: [PHP-DB] Cannot add header information error

2002-12-26 Thread Leif K-Brooks
You can't add headers after you've outputted anything. Without seeing the class page, I'd guess there's a space after the ?. Either remove that or use output buffering. Petre NICOARA wrote: Hi guys I have this error when I tried to use a sign-up form. The thing is that I use some classes for

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Ryan Jameson (USA)
for MS SQL and Oracle does anyone know a more reliable way to do this than select max(ID) immediately after the insert? It seems silly that I'd have to take my chances that another has been inserted in between. Ryan -Original Message- From: J.Veenhuijsen [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Bernain, Fernando G.
This is from de books online (MSSQL). @@IDENTITY (T-SQL) Returns the last-inserted identity value. Syntax @@IDENTITY Return Types numeric Remarks After an INSERT, SELECT INTO, or bulk copy statement completes, @@IDENTITY contains the last identity value generated by the statement. If the

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Ryan Jameson (USA)
This doesn't work as expected through ODBC... it does not seem to return any value... Ryan -Original Message- From: Bernain, Fernando G. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:09 AM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: NewB:

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Bernain, Fernando G.
You can use this inside an stored procedure, for instance: CREATE PROCEDURE SP_INSERT_TRANSACCION @transacfecha datetime, @observacion char(100) AS INSERT INTO Transaccion(transacfecha, observacion) VALUES( @transacfecha, @observacion ) SELECT @@IDENTITY AS 'nrotrans' END In this example, I

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Ryan Jameson (USA)
The problem is I have hundreds of tables each with a different column list and syntax, I don't want to have to create a SP for each table. There really has to be an easy way to do this. Now my sql server is saying this: Connection is busy with results for another hstmt, SQL state S1000 .

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Bernain, Fernando G.
It's not a bad idea to encapsulate de querys (selects, updates, inserts,...) in SPs... Good luck with the select max()!!! PD: If you dont want/can use identitys, maybe you can use another table where you store de next number of transaction. So its easy to update this number (plus one) and make a

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Ryan Jameson (USA)
Ok, this does work through ODBC as 2 seperate queries. This seems like a safer way to do it. I was trying to make it work as one insert query that returned the id. That was when I got the strange error message. Thanks! Ryan -Original Message- From: Bernain, Fernando G. [mailto:[EMAIL

[PHP-DB] postgresql vs mysql

2002-12-26 Thread Ellen Solomon
I'm starting a project for which the lead programmer wants to use postgresql.  I'll be working in php.  Any major disadvantages to postgresql over mysql, other than mysql seems to be more widespread? TIA Ellen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] postgresql vs mysql

2002-12-26 Thread Ryan Jameson (USA)
There's a substantiated rumor that says postgres is faster for complex queries. Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm starting a project for

Re: [PHP-DB] What's wrong with my update query select works, but updatedoesn't?

2002-12-26 Thread Michael Knauf/Niles
Here's the code: with some extraneous html removed to make it easier to read... ? require('connect.php') ? ? /* check for a request to display a new fg number and if so make sure the data is good if the fg number is good it is used for all other data queries */ $fgNumber=; if ($switchfg

RE: [PHP-DB] postgresql vs mysql

2002-12-26 Thread David Bryant
I've worked with both extensively. My personal preference is PG. However, here are my findings over the years. The biggest factor in performance is the size of the database, more than anything else. If you have a small and relatively simple RDB structure, MySQL is significantly faster. (this is

RE: [PHP-DB] What's wrong with my update query select works, but update doesn't?

2002-12-26 Thread Ryan Jameson (USA)
Well, it seems to me that if these two happen within the same scope level (same function, same class) which I cannot verify based on what you gave us, the $fgNumber should not be empty. Therefore I'd bet there's some code in between that reinitializes $fgNumber or the update is in a function

Re: [PHP-DB] Help Needed

2002-12-26 Thread Rick Widmer
At 02:36 PM 12/26/02 +0700, dufronte wrote: Hi. I juz installed a RedHat 8.0 on my machine. But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20.. Apache 2 and PHP are not ready for prime time. If you must use Apache 2 with PHP, you are on the bleeding edge, and should plan

RE: [PHP-DB] Help Needed

2002-12-26 Thread dufronte
I juz solved my problems last night... When I searched PHP.net.. I found out that PHP.4.3.ORC4 is compatible for APACHE2 but it isn't released yet... When I installed it.. it works... now I can use PHP in my APACHE2... Juz for information for somebody who have the same problem like me, you can

[PHP-DB] how to call a stored procedure in SQL Server 2000

2002-12-26 Thread Ha Duy Thien
Hi gurus, I am new user to PHP. Does anyone here work with SQL server with PHP, please show me some codes about how to call a stored procedure in a SQL Server Database. how to add paramaters also Thanks a lot Thien

[PHP-DB] how to call a stored procedure in SQL Server 2000

2002-12-26 Thread thien
Hi gurus, I am new user to PHP. Does anyone here work with SQL server with PHP, please show me some codes about how to call a stored procedure in a SQL Server Database. how to add paramaters also Thanks a lot Thien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] how to call a stored procedure in SQLServer 2000

2002-12-26 Thread Frank M. Kromann
Take a look at the documentation: http://www.php.net/manual/en/function.mssql-execute.php - Frank Hi gurus, I am new user to PHP. Does anyone here work with SQL server with PHP, please show me some codes about how to call a stored procedure in a SQL Server Database. how to add