[PHP-DB] PHP4.0.5 and PHP 4.0.6

...ive checked both versions, but they all have the same "error" inside. Lets start in the beginning. For several months my webserver has used mysql 3.23.38 AND php4.0.1 on Apache 1.3.12. I had never ANY problems so the motto was: Never touch a runnning system (oh murphy you are so damn

[PHP-DB] Date format in MSSQL

How I can format date in php query from MSSQL? Jack -- 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 administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Date format in MSSQL

Hi Have a look in Books Online - the e-docs for MSSQL - search for the convert function and all will be revealed. Peter - Original Message - From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 5:49 PM Subject: [PHP-DB] Date format in MSSQL How I can

[PHP-DB] Oracle and adodb recordcount

Hi, I've read that Oracle (oci8) doesn't support the adodb function RecordCount : it returns -1. Is it true with adodb 1.20 ? is there a smart workaround? thanks in advance, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] ODBC error

hi everybody, when i call to my file (my_file.php), the next error occurs: [the scenario] Winnt 4.0 SP6 IIS 4 php 4.0.5 [my_file.php] ?php $con = odbc_connect('the_dsn', '', ''); odbc_close($con); ? [the error: i translated it from the spanish (or at least i tried to...)]

[PHP-DB] PHP Ingres

Anyone using the Ingres routines in PHP 4.0.6 to access Ingres II? We have the problem that the database always sees the connection as coming from the username under which we run Apache, no matter what is specified in the ingres_connect() routine. Versions: PHP 4.0.6, Apache 1.3.20, Solaris 8,

[PHP-DB] multiple queries in one php statement....

Hello everyone... Could someone give me a tip ang tell me if i can insert more than one queries in a mysql_query() statement?? etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db) Thanks. ___ PGP KEY ID: 0xA86600E9 ___

Re: [PHP-DB] multiple queries in one php statement....

Could someone give me a tip ang tell me if i can insert more than one queries in a mysql_query() statement?? etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db) No, you can't. You've got to execute them one at a time. -- -Ryan :: ICQ - 595003 :: GigaBoard -

[PHP-DB] Error 127

Hi everybody, All of the sudden I got an error one of mysql tables. Got error 127 from table handler. Can't browse it not even from phpmyadmin get the same error. Anybody had this before? What do I do to recuperate my table? I really appreciate any help, Thanks, Cami -- PHP Database Mailing

[PHP-DB] Re: Error 127

the only time i've had this (not sure if it was 127) but i couldn't get the properties etc was after i named a table with a name that was a keyword. check the list in the docs as the list is quite long. i called mine 'returns' doh! Steve Cami [EMAIL PROTECTED] wrote in message [EMAIL

Re: [PHP-DB] Error 127

Cami, Here's what I found on the error and what to do about it: http://www.mysql.com/doc/R/e/Repair.html Hope that helps! My 2 ¢ John Pickett http://www.bvstudios.com/ Co-Author: Inside Dreamweaver 4 http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist - Original Message -

[PHP-DB] Re: Oracle and adodb recordcount

EOF shoud do the trick for my purpose (just want to know if my select returns a row or not). If not EOF just after a select, this means that the select returns at least one row. No more need to use recordcount. Thanks Philippe. Well, you're welcome, Philippe Regards, ... Philippe Philippe

RE: [PHP-DB] Error 127

Thanks everybody for pointing me to the right place. I manage to recover it. Thank God. Cami -Original Message- From: Cami [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 3:57 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Error 127 Hi everybody, All of the sudden I got an error

Re: [PHP-DB] Error 127

you know i did this last week and can't remember the functions is used. i had exactly the same problem but had to dump the records as plain text files. i used get_html_translation_table . if you look at the example in the compiled html help file for php there is a section of code that uses this

[PHP-DB] RE: Probably a stupid home server question ........

Make sure ahead of time whether the cable ISP gives you a static IP address or a dynamic one... Most of them in the US only give you dynamic IP's. They don't change all that often, but it does make it tough to host a domain name if your IP address is liable to change at any given moment. Also,

[PHP-DB] Error ORA-24327

I can connect my oracle server from apache with php function OCILogon(user,pwd,dbname); without problems... but sometimes when i reload the same web page i get the ORA-24327 error OCISessionBegin: Error while trying to retrieve text for error ORA-24327 My machine is a Sun solaris whit APACHE

[PHP-DB] Warning messages

Hi guys I've got a form in my web site which is working just fine, that is, it does everything I want, however whenever I load the page I get the following warning messages: Warning: Unable to open '' for reading: No such file or

Re: [PHP-DB] Warning messages

At 02:08 PM 7/19/01 -0500, Wilmar Pérez wrote: Hi guys I've got a form in my web site which is working just fine, that is, it does everything I want, however whenever I load the page I get the following warning messages: Warning:

Re: [PHP-DB] RE: Probably a stupid home server question ........

On Thursday 19 July 2001 19:25, Andrew Chase wrote: Make sure ahead of time whether the cable ISP gives you a static IP address or a dynamic one... Most of them in the US only give you dynamic IP's. They don't change all that often, but it does make it tough to host a domain name if your IP

[PHP-DB] Date Format

Friends, I have a design, up and running scripts connected to MySQL. How do I retrieve date formats and have it displayed as dd-mm- ? I store them as DATE. CK Raju -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[PHP-DB] Converting MS Access to MySQL

Can anyone suggest a good utility for converting database from MS Access to MySQL? Thanks. -- 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 administrators, e-mail: [EMAIL

Re: [PHP-DB] Converting MS Access to MySQL

yeah, cut and paste, jk, im curious too - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 2:15 PM Subject: [PHP-DB] Converting MS Access to MySQL Can anyone suggest a good utility for converting database from MS Access to MySQL? Thanks.

RE: [PHP-DB] Converting MS Access to MySQL

You can use ODBC to go from Access to MySQL. Get the MyODBC driver for Windows and setup your datasource so you can get to it via Access. You can do a direct export from Access to the MySQL database that way. There may be some differences, but I'm not sure of what all of them would be. Hope

Re: [PHP-DB] multiple queries in one php statement....

cant... since the function returns a code if the call is true or not. if you try multiple statements, you cant know which failed and which was good... Koutsogiannopoulos Karolos wrote: Hello everyone... Could someone give me a tip ang tell me if i can insert more than one queries in a

[PHP-DB] special characters in odbc-queries

Hi there, can anyone tell me, how I have to handle special characters in an odbc-query? for example: 'select * from $table where primary-key=\'1\' ' doesn't work because of the dash in primary-key Thx Kobi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] PASSWORD('xxxxx') and PHP

Is there a way to encode a string in PHP exactly like MySQL does it in its PASSWORD() Function? Reason being Is I have a table with PASSWORD() encoded fields that I need to compare from PHP. Thanks, Andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP-DB] Date Format

?php $date = 2001-07-19; // as if it just came from the db $date_array = explode('-',$date); $date = $date_array[1] . - . $date_array[2] . - . $date_array[0]; ? That should do it = Good luck! Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL