RE: [PHP-DB] Re: [PHP] Re: Cross DB application

2002-04-17 Thread SP
There must be people on this list that have ported their web apps from different databases and could share their experiences. mysql <-> postesql mysql <-> ms sql server ms sql server <-> oracle -Original Message- From: John Lim [mailto:[EMAIL PROTECTED]] Sent: April 17,

RE: [PHP-DB] Re: [PHP] Re: Cross DB application

2002-04-18 Thread SP
EMAIL PROTECTED]] Sent: April 18, 2002 9:37 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sp Subject: Re: [PHP-DB] Re: [PHP] Re: Cross DB application Hello, Sp wrote: > > Can someone with database expertise who has used metabase and adodb cut > through this rhetoric and give an objective

RE: [PHP-DB] stripSlashes function

2002-05-20 Thread SP
You need to add slashes when putting data into your database. When you want to display the data from your database, that's when you strip the slashes. -Original Message- From: Lisi [mailto:[EMAIL PROTECTED]] Sent: May 20, 2002 5:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] stripSlashe

RE: [PHP-DB] stripSlashes function

2002-05-20 Thread SP
VALUES ('Michael O'Dell', '[EMAIL PROTECTED]', '123 Street') You see the extra ' in the sql statement? So let magic quotes insert the slashes when inputing text but when you want to display it again then you have to stripslashes. -O

RE: [PHP-DB] How to store an image into a db?

2002-05-25 Thread SP
Here's just one of many articles on this subject: http://www.phpbuilder.com/columns/florian19991014. php3 You can also do a search and read the debates about whether this is a good idea or not. -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: May 25, 2002 4:38 AM To: [EMAI

[PHP-DB] arranging folders hiearchy

2002-06-08 Thread SP
I am trying to arrange the results by PATH but within each of the same PATH section I want it to be arranged by NAME alphabetically so it looks like the following below. I've tried a bunch of order by's but not getting it to work. Is this possible to do? Or do I have to change my PATH data some

RE: [PHP-DB] arranging folders hiearchy

2002-06-08 Thread SP
Wrong: 10 7 ' 1 3 10' 'Repairs' Correction: 10 3 ' 1 3 10' 'Repairs' -Original Message- From: SP [mailto:[EMAIL PROTECTED]] Sent: June 8, 2002 8:09 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] arranging f

RE: [PHP-DB] arranging folders hiearchy

2002-06-09 Thread SP
rformance and only rebuild it after you modify any of the values in the original table. Feel free to write back if you have more questions. Good luck, Frank On 6/9/02 6:18 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > From: "SP" <[EMAIL PROTECTED]>

RE: [PHP-DB] Can I be an ASP with PHP?

2002-06-21 Thread SP
If your database server is on a remote server then expect the page to take even longer to render since it will take time to send the database query info back and forth between the two servers. -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: June 21, 2002 11:06 AM To: Re