Re: [PHP-DB] Slashes

2003-12-09 Thread Ng Hwee Hwee
my my!! you are so right, John! thank you so much! i thought I was trying to escape those commands like but I wasn't aware they were trying to addslashes for me too! you are my saviour... thanx so much.. just a quick question.. does it mean, i don't have to worry that my user may type any comma

Re: [PHP-DB] Slashes

2003-12-09 Thread John W. Holmes
Ng Hwee Hwee wrote: $value = trim(EscapeShellCmd($fieldName)); and then i do a $query= "insert into table set name='$value'"; i swear i did not add any slashes twice (at least for what i know!!).. is there another way that i could have addslashes twice without my knowing?? Heh... look at the outp

Re: [PHP-DB] Slashes

2003-12-09 Thread Ng Hwee Hwee
Hi John, thanx!... HH > but why is it that I still get a backslash HH > before an occurrence of a single-quote? HH > for example, HH > HH > where $fieldName is retrieved from the database through: JH > Maybe magic_quotes_runtime is enabled? It will add slashes to data from JH > files and databa

Re: [PHP-DB] Slashes

2003-12-09 Thread John W. Holmes
Ng Hwee Hwee wrote: > but why is it that I still get a backslash > before an occurrence of a single-quote? for example, where $fieldName is retrieved from the database through: Maybe magic_quotes_runtime is enabled? It will add slashes to data from files and databases. Bottom line, if you actual

[PHP-DB] Re: Transfering large mysql database

2003-12-09 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] digital.nl says... > You can use phpmyadmin to export structure and data. > You have to be aware that the first line of the output > has to commented (# at start of line) > Otherwise phpmyadmin generates an error. > > Jochem > > > Harlan Lax wrot

[PHP-DB] Slashes

2003-12-09 Thread Ng Hwee Hwee
hi all, i need help on my slashes.. i saw php.net say: "Do not use addslashes() on strings that have already been escaped with magic_quotes_gpc as you'll then do double escaping." with that, i also did not do a stripslashes when i retrieve my data, since my magic_quotes_gpc is on.. but why is

[PHP-DB] Re: Transfering large mysql database

2003-12-09 Thread Nikos Gatsis
Why dont you gzip the files of database and write them in a CD? Its safe and (maybe) faster if the tables are large files. Nikos > - Original Message - > From: "J.Veenhuijsen" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, December 09, 2003 1:13 PM > Subject: [PHP-DB] Re:

RE: [PHP-DB] PostgreSQL on Windows

2003-12-09 Thread Mike U. Petrov
I think yes. For more information see http://techdocs.postgresql.org/guides/InstallingOnWindows Mike U. Petrov -Original Message- From: Rosen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 6:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PostgreSQL on Windows Hi, Can I start

[PHP-DB] PostgreSQL on Windows

2003-12-09 Thread Rosen
Hi, Can I start PostgreSQL server and client on Windows machine ? Thanks in advance! Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] counting horly statistics

2003-12-09 Thread Chris Bolson
Hello, I need a bit if help getting accurate hourly statistics from my web. I am using: php-mysql The DB table saves every page hit recording : id (auto increment), ip, session, timestamp and other non interesting web specific data. I do a summary of hits per weekday using the following quer

[PHP-DB] Re: Transfering large mysql database

2003-12-09 Thread J.Veenhuijsen
You can use phpmyadmin to export structure and data. You have to be aware that the first line of the output has to commented (# at start of line) Otherwise phpmyadmin generates an error. Jochem Harlan Lax wrote: Does anyone have a recomendation on an app that will help me transfer a large table f