Re: [PHP-DB] php5 and mysql_connect

2004-12-05 Thread it clown
Hi Sorry i ment i am running php5 on suse 9.1.When i run php -m i receive: [PHP Modules] ctype dom iconv libxml pcre posix session SimpleXML SPL SQLite standard tokenizer xml How do i load mysql under the modules?Is this why mysql_connect is not working? Regards On Sun, 05 Dec 2004 13:50:39

[PHP-DB] PHP unpredictable with connection to MySql

2004-12-05 Thread Jamie Marshall
Can someone please help me? I am running Apache 2 with mysql 4.1 and php 4.3.9 on windows xp home. I have altered the apache config files as well as the php ini files I am able to successfully run php scripts from my localhost. I also have successfully installed MySql (knowing this as I can

[PHP-DB] Pagination

2004-12-05 Thread Valerie
It shows next and the first 10 records but will not bring up the next 10 when next is pressed. ?php require ('db_params.inc'); if(!$start) $start = 0; $query2 = 'SELECT count(*) as count ' . ' FROM `Wellington` ' . ' WHERE`location`=Hills'; $result2 = mysql_query($query2);

[PHP-DB] pagination

2004-12-05 Thread Valerie
It shows next and the first 10 records but will not bring up the next 10 when next is pressed. ?php require ('db_params.inc'); if(!$start) $start = 0; $query2 = 'SELECT count(*) as count ' . ' FROM `Wellington` ' . ' WHERE`location`=Hills'; $result2 =

[PHP-DB] connection pooling

2004-12-05 Thread Jan Bro
Hello List, is there anybody out there, who could help me in finding something I know from good old java: Connection Pooling. Is there a mechanism or project that provides that for PHP 5? Reason I create a 20 page pdf with data out of MySQL 4.1 (that means using the mysqli methods) where I

RE: [PHP-DB] connection pooling

2004-12-05 Thread Trevor Gryffyn
I don't know about connection pooling in Java, but a couple of thoughts arise with this question: 1. If it's connection/disconnect/reconnection that's causing the bottleneck, why not just connect once, perform your various SELECTs to get your data then close the connection once at the end? You

[PHP-DB] Re: connection pooling

2004-12-05 Thread Manuel Lemos
Hello, On 12/05/2004 05:42 PM, Jan Bro wrote: is there anybody out there, who could help me in finding something I know from good old java: Connection Pooling. Is there a mechanism or project that provides that for PHP 5? Reason I create a 20 page pdf with data out of MySQL 4.1 (that means using