Re: [PHP-DB] What PHP4 use for connection to MSSQL?

2001-04-17 Thread John Lim
""Frank M. Kromann"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > ODBC and ADO uses the same type of connection. In fact you need an ODBC DSN to connect to a database using ADO. Not quite true. ADO is designed so that it can use ODBC internally, or a differ

[PHP-DB] really more of an oracle question

2001-04-17 Thread Brian.J.Mauter
Hey everyone, please disregard this off-topic question. I think I may need some PHP knowledge too, but here goes. In all of the documentation I've found, a DBA can write stored procedures, functions and views. I know how to write a stored procedure to do INSERT, UPDATE or DELETE functions. I r

[PHP-DB] MySQL Question

2001-04-17 Thread Peter J. Krawetzky
How do you move the database files to another location in MySQL? I am running Redhat 7.1 with MySQL version 3.23.33. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrator

Re: [PHP-DB] php with mysql or interbase?

2001-04-17 Thread joel
Thanks, but instead of sifting through all the individual messages I wanted to see if there were any comments that summarize the whole thing. If there are not my conclusion is that there is more free documentation and support for mysql than interbase. I even found a new book at Barnes and Noble

Re: [PHP-DB] PHP Forms

2001-04-17 Thread CC Zona
In article <001201c0c77c$a0262360$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Hector M Banda") wrote: > I want to know how can I store all the forms in a place where users can run > them but are not available to the owner of the domain. See the following for pages for info on using an include_path

[PHP-DB] PHP Forms

2001-04-17 Thread Hector M Banda
Hi all, I'm doing virtual domains for some friends where have a form where I'm capturing some user information ( name, lastname, etc) to e-mail and also to store the information using PHP. Everything is working ok but I'm placing all the PHP forms on the user's directory and they are accessibl

[PHP-DB] PHP/OCI8 design for persistent connection tuning

2001-04-17 Thread Dave Thomas
Hi, Thanks to all who helped me getting OCI compiled. I've started doing some stress testing and overall, I'm pleased with the results. I suppose that it would be nice to have connection pooling ala-ProC, but I hear that's on it's way. So I'm starting up apache with like 120 servers. I hit

Re: [PHP-DB] php with mysql or interebase?

2001-04-17 Thread Doug Semig
[In a deadpan voice...] Oh, what a fascinating twist. http://marc.theaimsgroup.com/?l=php-db is where this particular list is archived. That's where you can learn a lot about the individual programs, and you may find out little bits of wisdom like: each database has strengths and weaknesses,

Re: [PHP-DB] Forms and PHP

2001-04-17 Thread JD Daniels
Odd. I don't think I have EVER posted to this group.. Been reading a long time.. I wonder how I sent this :) Anyway, I have couple of suggesttions for [EMAIL PROTECTED] Try echoing back the post values like this: extract($HTTP_POST_VARS); echo $; # Or what ever the name of the form fields i

[PHP-DB] php with mysql or interebase?

2001-04-17 Thread joel
I'm trying to decide whether to use interbase or mysql with php. Both are free and both have a php api. So with is better to use with php? Or does it matter? [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: [PHP-DB] What PHP4 use for connection to MSSQL?

2001-04-17 Thread Frank M. Kromann
ODBC and ADO uses the same type of connection. In fact you need an ODBC DSN to connect to a database using ADO. The MSSQL functions in PHP uses a native communication with the database. This communications is faster than using ODBC but it is not as easy moving to other databases as it would be

Re: [PHP-DB] PHP + Interbase

2001-04-17 Thread Johannes Janson
Hi, check the relevant configure-flag for interbase. most likely to be something like --with-interbase. just type ./configure --help |more and you'll get a lng list of options. Johannes <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Quiero instalar

[PHP-DB] PHP + Interbase

2001-04-17 Thread bnunez
Quiero instalar PHP con apache en linux y conectarme a un servidor interbase corriendo en solaris. Ya tengo php, que mas necesito para "activar" la conexion a interbase?. I have a database in solaris (in interbase) and I need to conect to that database. Now there is installed PHP in linux with a

Re: [PHP-DB] A bit of help with a query needed.

2001-04-17 Thread Johannes Janson
Hi, > $result2 = mysql_query("SELECT * FROM convicts WHERE ship = > '$id' ORDER BY convict",$db); > $row = mysql_fetch_array($result2) // ! you are missing a ";" this is where you get the parse error from! > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe,

RE: [PHP-DB] A bit of help with a query needed.

2001-04-17 Thread Howard Picken
Thanks for that. I've cleaned up things a bit for the time being. I'm still getting an error though. Parse error: parse error in c:\usr\local\www\pages/ships.php on line 30 Line 30 turns out to be $convict = $row["convict"]; so I'm assuming that it's having trouble with the array. I've tried

Re: [PHP-DB] Error messge regarding session variables

2001-04-17 Thread Johannes Janson
Hi, cookies are sent as header information. This means you can't send any output (html-tag, whitespaces before schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > i've got error message when i put some session variables on my pagge: > > Warning: Cannot send session cookie - hea

Re: [PHP-DB] Error messge regarding session variables

2001-04-17 Thread Russ Michell
Make sure you have nothing between your 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]

[PHP-DB] Error messge regarding session variables

2001-04-17 Thread Dan Guja
i've got error message when i put some session variables on my pagge: Warning: Cannot send session cookie - headers already sent by (output started at /home/httpd/vhosts/coliba.freephp.digiro.net/htdocs/user/index.php:4) in /home/httpd/vhosts/coliba.freephp.digiro.net/htdocs/user/index.php on l

Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-17 Thread Johannes Janson
Hi, i don't get that. Examlpe: tablename: test , entry: id 001; name: John Doe $result = mysql_query("SELECT * FROM test"); $row = mysql_fetch_whatever($result); // everything ok $result = mysql_query("SELECT * FROM tet"); $row = mysql_fetch_wahtever($result); // Warning: Supplied arggument is

Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-17 Thread Klaus Haberkorn
thank You, Johannes, but I think we can skip this, we reduced the query statement to the most simple one: "SELECT * FROM {tablename}" if the tablename is wrong, then another error message is issued. the result is not treated by a while-loop but just by fetch_num_rows, which at least reports the er

[PHP-DB] What causes error 127 from table handler

2001-04-17 Thread Jens Kisters
Hi there, i got an error message got error 127 from table handler Last time i got that i lost a few rows in the affected table, but i thought that resulted from copying the db-files without shutting down the database, but the system i got the message from this time never had operations like this

Re: [PHP-DB] A bit of help with a query needed.

2001-04-17 Thread Johannes Janson
Hi, which part is not working? Put a "or die(mysql_error())" behind your queries to see which one produces an error. like this: $result = mysql_query("SELECT * FROM ships ORDER BY ship",$db) or die(mysql_error()); > > while ($row = mysql_fetch_array($result)) { > > If ($result) { >

Re: [PHP-DB] What PHP4 use for connection to MSSQL?

2001-04-17 Thread John Lim
For some examples of connecting PHP to ODBC, visit http://php.weblogs.com/odbc As to speed, definitely MSSQL using PHP is very fast. See some benchmarks: http://php.weblogs.com/adodb_benchmarks Try the ADODB database wrapper library also. It's ADO for PHP! http://php.weblogs.com/adodb (I'm the a

[PHP-DB] What PHP4 use for connection to MSSQL?

2001-04-17 Thread Yevgeny Dyatlov
Hello , Can somebody help me with a question: ASP use for connection to MSSQL the OLE DB for SQL Server, someone tell that it's cool because it better & faster than ODBC. But in PHP4 there are functions both for ODBC & MSSQL. In FAQ on www.php.net - 'On Windows 95/NT machines, you can s

[PHP-DB] A bit of help with a query needed.

2001-04-17 Thread Howard Picken
I'm trying the get PHP(and MySQL) to produce a page that grabs ship date (unique) from one data table and then adds a list of all the convicts that were on the ship. something like this... Anaconda One voyage only Male convicts on board Sail date 12 Oct 1823 Convicts on board were: Joe Bloggs

Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-17 Thread Johannes Janson
Hi, you usually get the error if your query is wrong and you try to call mysql_fetch_array in a while loop. It's easier if you post the relevant lines of code but I'd say there is something wrong with your query. Johannes ""Klaus Haberkorn"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 9bh369$d

[PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-17 Thread Klaus Haberkorn
Installation Details: SuSE Linux 7.1 kernel 2.4 + apache 1.3.14 + php4.0.4pl1-1 + mysql 3.23.30-2 The following error message appears: "Warning: Supplied argument is not a valid MySQL result resource in /www/wp/php/login.php on line 29" Remarks: php4 runs fine and returns "not FALSE" for functio

Re: [PHP-DB] How to back up database..... ?

2001-04-17 Thread Xsarus Internetdiensten
mysqldump... - Original Message - From: "E K L" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 15, 2001 9:40 AM Subject: [PHP-DB] How to back up database. ? > Hi all, >Is there anyone can tell me how to back up Mysql database from one server > to other server? P