Re: [PHP-DB] AGONIZING Mysql Select DB issue.

If you are doing this: $dbh = mysql_connect("db1", blah blah blah); $dbh2 = mysql_connect("db2", blah blah blah); Then $r = mysql_query("select * from mytable"); will use the db2 connection, because it is the most recent. However, if you do this: $r = mysql_query("select * from mytable", $dbh

Re: [PHP-DB] Transferring MySQL data.

Hugh, Nothing is a stupid question. you can transfer databases by doing a Machine# mysqldump -a -c -p insert_db_name_here > backup.sql on your home machine, and then doing a Machine_prod# mysqladmin -p create database_name Machine_prod# mysql -p database_name < backup.sql after you have transferre

[PHP-DB] AGONIZING Mysql Select DB issue.

Here's the stats: Two servers: Server 1, Mysql 4.0.12, PHP 4.3.2, apache 1.3.27 Server 2, Mysql 4.0.14, PHP 4.3.2, apache 1.3.27 My HTTP is setup on Server 2 (and server 1 as well) I'm setting up a mirror on Server 2 and it connects to the DB on server 1. Privs are setup that user has DB access

[PHP-DB] Transferring MySQL data.

This is probably a stupid question, but I'm pretty new at this! Having built test MySQL databases for my website on my home machine, is it possible to transfer the data straight to a web hosting company's server or do I need to rebuild the databases again from scratch? Thanks for any input, Hu

[PHP-DB] changing properties of an image dynamicly

Hi, how can I change the size-properties of an image that I take from a database dynamicly to a new format. The original picture can be different in size and should become a new fixed size. Also interessting for me is when I have s list of pictures with different original size and I will reduze t

[PHP-DB] Re: PHP Oci8 segmntation fault

Hi, Thanks for the help. I will try this, althought i compiled php with-oracle and Oracle functions work ok with php even in command line. Now, only i have problem with calling oracle stored procedures that return resultset in cursor. I knew how to do it in oci functions, but i dont know how to ma

[PHP-DB] Re: mount command with php in through the web

check out webmin http://www.webmin.com this allows you to administer thewhole server over the web ;-) Suman Aluru wrote: Hi All, is there any way i can run mount command with php script in the web , bcz. mount command run only for super user as apache user is there any way to run. plz. help me

[PHP-DB] Re: adding integer to field in query

is the field null ??? - make sure it has zero as a default value John Dillon wrote: How do you add a number to a field within the query, ie without having to extract? Eg $query="UPDATE Choice SET visits=(visits+1) WHERE ID='$thisID'"; is the above "visits=(visits+1)" legal, cos it doesn't work a

[PHP-DB] Re: Maximum execution time of 30 seconds exceeded

http://ca2.php.net/manual/fr/function.set-time-limit.php thats it... Stephane Tessier - dev team leader Above Security "Michael Cortes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I am using the Konqueror browser and browing to http://localhost/my.php Hower

[PHP-DB] Re: PostgreSQL connection

take a look at your postgresql.conf config optimize request and test your requests "Joe Nilson Zegarra Galvez" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all, i have a question, i have a php file with all my class to > connect into a postgresql db and i'm using the pg_conne