escape ' with '' or \'

searain

To escape ', such as O'reilly, most databases do this with a \ which would mean O\'reilly.

But some databases ask to escape the ' with ''.

1) So escape ' with \' or '' depends on which database you use?

2) if the database ask to escape ' with '', i cannot use the addslashes to do the escape job?

Could someone advise here?

Thanks!

chriskl

It depends on your database.

I suggest using pg_escape_string or mysql_escape_string, not addslashes.

Chris

laserlight

Generally using 2 single quotes would be correct.

MySQL does accept '' instead of \', but I suppose we're all getting too used to escaping with the backslash.

bufhal

Hello.
I am a newbie and trying to query a text file on a server for specific fields. The text file is going to contain 2-300 records. The records are to be comma delimited and contain 7-9 columns. All records will be laid out exactly the same. I want the user to be able to pull certain dates a user requests (e.g. xx/xx/xxxx). This will be one of the search buttons on the webpage. The other two will be simple dropdowns because theere are not alot of neteries.

Sorry about the long-wininess of this but my question is:
What is the best way to access a textfile for certain records in one column (e.g. date?)

Any direction or help is greatly appreciated..
Bufhal

ahundiak

Bufhal Wrote
What is the best way to access a textfile for certain records in one column

I would certainly recommend using either quotes or slashes. Or perhaps it might be best to just not hijack the thread.

bufhal

Wow, sorry to interupt all the excitement. "Highjack" the thread??Perhaps a pleasant reply directing a first-timer to the right thread would be more constructive......