[PHP-DB] Re: PHP connection to remote Access database on NT

2003-09-11 Thread nabil
Yes , and I done myself to mssql on windows from linux/apache you have to use odbc .. use FreeTDS , it is free and open soured... and work like a charm Nabil John Almberg [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Here's a question I hoped I'd never have to ask... Is it

[PHP-DB] Re: backing up MySQL

2003-09-11 Thread nabil
use the following script ## #!/bin/sh # Create the temporary copy directory mkdir /tmp/mysql # Get the list of MySQL Databases copy them for var in `find /var/lib/mysql/ -type d | \ sed -e s/\/var\/lib\/mysql\///`; do mysqlhotcopy -q $var /tmp/mysql done # Tar/gzip data

Re: [PHP-DB] Re: backing up MySQL

2003-09-11 Thread Hendri
how about just hard copy /var/lib/myql/ directory and then restore them as ordinary copy file scheme ? it works for me, and with no something strange Hendri, Hobbyst Coder -Original Message- From: nabil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Thu, 11 Sep 2003 09:42:44 +0200

[PHP-DB] stupid mySQL connect \ pconnect problems - pls help

2003-09-11 Thread BOb Pardoe
I am running the latest Apache2 and PHP 4.3.3 and mySQL 4... I have installed php as a module in apache. I cannot connect to the locally installed mySQL database. It complains that the server cannot be found I am doing the following $Conn = mysql_pconnect($Server, $User, $Pwd); I

Re: [PHP-DB] Re: backing up MySQL

2003-09-11 Thread John W. Holmes
Hendri wrote: how about just hard copy /var/lib/myql/ directory and then restore them as ordinary copy file scheme ? it works for me, and with no something strange You can do that, but you need to shut down MySQL first. If you don't, one of these times you'll run into trouble. -- ---John

[PHP-DB] help newcomer

2003-09-11 Thread SAGERAT
Hi, I try to make a php script for update news. It does not work. Could you please help. Here is the input page. http://www.minsel.org/news_input.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] how many rows updated

2003-09-11 Thread Jason S Motes
When updating or deleting a table is there anyway to find out how many rows where affected using php?? I am using Postgresql 7.2 and php 4.2 using pgsql from the the command line I enter this query update teststock set item_num ='something' where item_num ='something'; and it returns UPDATE

Re: [PHP-DB] how many rows updated

2003-09-11 Thread John W. Holmes
Jason S Motes wrote: When updating or deleting a table is there anyway to find out how many rows where affected using php?? I don't even use PG, but it took me 5 seconds to find this: http://us2.php.net/manual/en/function.pg-affected-rows.php -- ---John Holmes... Amazon Wishlist:

Re: [PHP-DB] how many rows updated

2003-09-11 Thread Jason S Motes
Thanks, i could not find that function in the book i was using. sorry for the inconvenience. John W. Holmes wrote: Jason S Motes wrote: When updating or deleting a table is there anyway to find out how many rows where affected using php?? I don't even use PG, but it took me 5 seconds to find

[PHP-DB] best upload method

2003-09-11 Thread open-mind
which is the best upload file method ? file uploads or FTP commands from PHP thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how many rows updated

2003-09-11 Thread Tyler Lane
Jason S Motes wrote: Thanks, i could not find that function in the book i was using. sorry for the inconvenience. John W. Holmes wrote: Jason S Motes wrote: When updating or deleting a table is there anyway to find out how many rows where affected using php?? I don't even use PG, but it