[PHP-DB] php5 and mysql_connect

2004-12-05 Thread it clown
Hi All, i have installed php5 and mysql on 9.1 and when i use php to connect to mysql i get the following error: Fatal error: Call to undefined function mysql_connect() Why is this happening and how do i fix it? My php script is correct i double checked. Thanks Regards

Re: [PHP-DB] php5 and mysql_connect

2004-12-05 Thread Jochem Maas
hi Clown, php5 has a new set of functions for mysql, these are all named mysqli_* instead of mysql_* - this has to do with the problems surrounding mysql licensing (the work around was, I believe, to write a new set of functions which were not tied to the mysql lic.) anyway mysql_connect() won't

[PHP-DB] Checkboxes on repeat regions

2004-12-05 Thread Stuart Felenstein
I have this form that is set up like this: Repeat Region 1 [From mysql recordset] +---+---+---+ | HTML checkbox | Profile Name | Edit Button | +---+---+---+ So if the user went to this page it would show a list of their pr

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 creat

[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. $result2 = mysql_query($query2); $row2 = mysql_fetch_array($result2); $numrows = $row2['count']; if($start > 1){ echo "Previous"; } if($numrows > ($start + 10)){ echo "Next"; } $query='SELECT

[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. 1){ echo "Previous"; } if($numrows > ($start + 10)){ echo "Next"; } $query='SELECT * ' . ' FROM `Wellington` ' . ' WHERE`location`="Hills" ORDER BY `LotNo` ASC L

[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 require

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 s

[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 th

[PHP-DB] Mozilla inserts twice, IE does OK... ?

2004-12-05 Thread Steven \[Offstage\]
Hi there, First post to this mailing list, and I have a very strange problem: I'm using Apache2 with PHP 4.3.9 and MySQL 4.0.21. Sometimes when I execute an INSERT-query using mysql_query, the data is inserted twice. I'm 150% sure the code is only executed once! I tried this by adding 'echo "te

Re: [PHP-DB] PHP unpredictable with connection to MySql

2004-12-05 Thread Micah Stevens
It's probably stopping due to an error, but no error message is being displayed. Make sure you try and echo mysql_error() to the screen to see if that helps. -Micah On Sunday 05 December 2004 06:53 am, Jamie Marshall wrote: > Can someone please help me? > I am running Apache 2 with mysql 4.1