Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread ramki
Generally in DBs, data is case sensitive. Simply you can do an uppercase or lowercase conversion in both sides. Ex : Select item number from item where upper(item_code) = upper("m1234"); -ramki - Original Message - From: "Larry Sandwick" <[EMAIL PROTECTED]

Re: [PHP-DB] Is it possible to access MySQL table on server A from server B?

2003-10-08 Thread ramki
mysql_dump (backup). You can write a ftp code in php. get all the source code in the old server and write it in the new server. -ramki - Original Message - From: "Trisha" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 08, 2003 12:23 PM S

Re: [PHP-DB] How to get data from excell file?

2003-09-02 Thread ramki
Hi To my knowledge, there isnt any function. you could try setting a dsn for xl file and use it through odbc in php. -ramki SpychaƂa Wojciech wrote: I want to get data from excell file. Is there in php some function making it possible? For example something like functions reading from dbf&#

Re: [PHP-DB] Database backup

2003-08-27 Thread ramki
mysqldump -A > /path_to_file/filename.sql for eg: mysqldump -A > /tmp/alldatabases.sql This generates a sql file which can be used as backup or for restore... Hope it helps.. -ramki Chris Payne wrote: Hi there everyone, Is there a quick way I can backup all my databases on Linux so