Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-07 Thread Sean Burlington
Gnanavel wrote: $output=exec(cp file1 file2); echo pre$output/pre; does not works. can any one help me out of this problem When I was executing the cp command it doesn't return anything. But it returned the name of the last file when i executed the ls `cp file1 file2` doesn't return anything -

[PHP-DB] copy tables between db's

2003-09-07 Thread Jeremy
I need to copy some tables from one mysql database to another mysql database on the same server. I looked at the php manual and couldn't find it...I found stuff on mysqlhotcopy, but it doesn't look like that will do what I need it to do, or maybe I'm reading the manual wrong. Can someone please

Re: [PHP-DB] copy tables between db's

2003-09-07 Thread David Smith
Have you tried something like this: insert into database1.tablename select * from database2.tablename; database1 and database2 are the names of the two databases. tablename is the name of the table you want to copy from database1 to database2. In your case I guess this would be: insert

Re: [PHP-DB] copy tables between db's

2003-09-07 Thread David Smith
David Smith wrote: insert into database1.tablename select * from database2.tablename; database1 and database2 are the names of the two databases. tablename is the name of the table you want to copy from database1 to database2. Correction: from database2 to database1, not vice versa.

Re: [PHP-DB] copy tables between db's

2003-09-07 Thread John W. Holmes
Jeremy wrote: I need to copy some tables from one mysql database to another mysql database on the same server. I looked at the php manual and couldn't find it...I found stuff on mysqlhotcopy, but it doesn't look like that will do what I need it to do, or maybe I'm reading the manual wrong. Can

[PHP-DB] PHP Safe Mode ...

2003-09-07 Thread James Hatridge
Hi all,,, I'm having hell with this !ยง$ PHP safe mode. It seems that SuSE complies PHP with safe mode = on. THEREFORE the config file php.ini can not turn it off. Can someone who is using PHP exec in SuSE 8.2 give me an idea how they are doing it? OR how to work around this. Here is my

Re: [PHP-DB] Dynamic sites, to appear static...?

2003-09-07 Thread Lisi
Sorry I'm a bit late with this, I couldn't remember where I'd seen this: http://www.zend.com/zend/spotlight/searchengine.php has an article on getting around this. I've used it and it's pretty easy to do. HTH, -Lisi At 11:18 AM 9/4/03 +0100, [EMAIL PROTECTED] wrote: I've been building web

[PHP-DB] Re: Approved

2003-09-07 Thread L-Soft list server at Computer Associates International (1.8e)
Please see the attached file for details. Unknown command - PLEASE. Try HELP. Summary of resource utilization --- CPU time:0.000 sec Overhead CPU:0.000 sec CPU model: 4-CPU 700MHz Pentium III Xeon 1M (2048M) Job origin: [EMAIL PROTECTED]

[PHP-DB] Selection problem

2003-09-07 Thread Chris Payne
Hi there everyone, I'm having a strange problem, I have a form with 2 fields, 1 is for points (Weightwatcher points) and one is for recipe names. If you select points (IE: 1-3, 3-6,6-9,9 and above) it works perfectly, displays the recipes and allows you to select a new points range from the

[PHP-DB] [SPAM?] [PHP-DB] Re: Approved

2003-09-07 Thread L-Soft list server at Computer Associates International (1.8e)
This mail is probably spam. The original message has been attached along with this report, so you can recognize or block similar unwanted mail in future. See http://spamassassin.org/tag/ for more details. Content preview: Please see the attached file for details. Unknown command - PLEASE.

Re: [PHP-DB] Selection problem

2003-09-07 Thread Micah Stevens
Since you didn't include the form, I'm going to have to make a couple of assumptions: $nameb is the recipe field. $pointsb is the points field. You want to use SQL statement 1 if they select points, 2 if they select recipies, but those aren't the only possibilities with the form. It sounds to

[PHP-DB] Re: Compiling 4.2.3 with MySQL ... what does it look for?

2003-09-07 Thread Nabil
Hi if you compiled apache with prefix /usr/local/apache (i use apache_1.3.28.tar) and you put your mysql binary into /usr/local/mysql (i use mysql-standard-4.0.14-pc-linux-i686.tar) then you configure php (i use php-4.3.2.tar ) ./configure --prefix=/usr/local/php --with-config-file-path=/etc