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? Please

[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

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

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) { $id

[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

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

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

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 ?php) at all before sending cookie/header information. As your error message tells you the output already started in line 4. Move the cookie-part from line 6 to the beginning and it

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

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,

[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

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

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,

[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

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