Re: [PHP-DB] timestamp value management

2006-02-01 Thread Julien Bonastre
Or... If one were to actually RTFM in reference to the mysql manual. Freely available at: http://dev.mysql.com/doc/refman/4.1/en/index.html [or substitute 5.0 for us hardcore mysql'ers ;-) mysql5 is swet. ] Heres an interesting, difficult to find page [joke]

[PHP-DB] Re: Amount of characters a variable is able to contain

2006-02-01 Thread Mathieu Dumoulin
I'm not sure where you are heading with this, but here goes, if you want to keep lots of data in mysql (PHP should not truncate your data) just use a LONG TEXT or TEXT... If im not mistaken, TEXT take 2^16 characters, so approximately 4 million characters while LONG TEXTS can take several

[PHP-DB] Performance question

2006-02-01 Thread Mathieu Dumoulin
This is more a How would you do it than a How can i do it question. Didn't have time to try it, but i want to know how mysql_seek_row acts with large result sets. For example im thinking of building a node tree application that can have dual direction links to nodes attached to different

[PHP-DB] pdo and oracle drivers

2006-02-01 Thread Pablo Godel
Hello, I've been playing around with PDO and oracle drivers. PDO seems to be the right way to go, but the oracle implementation it is still very immature and prepare statements don't seem to work. I am using oracle instant client 10.2 The problems I found are when doing prepared statements.

Re: [PHP-DB] Performance question

2006-02-01 Thread Miles Thompson
Don't cross post!! MT At 11:46 AM 2/1/2006, Mathieu Dumoulin wrote: This is more a How would you do it than a How can i do it question. Didn't have time to try it, but i want to know how mysql_seek_row acts with large result sets. For example im thinking of building a node tree

[PHP-DB] How to compare crypted password with stored in MySQL

2006-02-01 Thread Eduardo Bejar
Hi, I have a MySQL database with encrypted passwords, that were created with: $input_password = $_POST[password]; $salt = ab; /// Salt is always two character string and the same for all $password_to_save = crypt($input_password, $salt); and then saved in MySQL with: insert into

Re: [PHP-DB] How to compare crypted password with stored in MySQL

2006-02-01 Thread Philip Hallstrom
On Wed, 1 Feb 2006, Eduardo Bejar wrote: Hi, I have a MySQL database with encrypted passwords, that were created with: $input_password = $_POST[password]; $salt = ab; /// Salt is always two character string and the same for all $password_to_save = crypt($input_password, $salt); [snip]

Re: [PHP-DB] How to compare crypted password with stored in MySQL

2006-02-01 Thread Mark Bomgardner
Eduardo Bejar wrote: Hi, I have a MySQL database with encrypted passwords, that were created with: $input_password = $_POST[password]; $salt = ab; /// Salt is always two character string and the same for all $password_to_save = crypt($input_password, $salt); and then saved in MySQL with:

[PHP-DB] php 5.1.2 and mysql 5.0.18 problem: Lost connection to MySQL server during query

2006-02-01 Thread Filippo Mesirca
Hello! I tried to compile a LAMP system, but I'm having troubles in making MySQL and Apache+PHP to communicate: I've compiled apache-2.2.0, and, as the title says, mysql-5.0.18 and php-5.1.2. The ./configure options I passed when building mysql-5.0.18 are: export CFLAGS=-O2 -march=i486