Re: [PHP-DB] Escaping an '

2010-10-17 Thread Bastien
Mysql_real_escape_string($bar) Bastien Koert 905-904-0334 Sent from my iPhone On 2010-10-16, at 10:41 PM, Ron Piggott ron.pigg...@actsministries.org wrote: For a query similar to: SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor' how do I escape the ' for 's? -- PHP

[PHP-DB] Escaping an '

2010-10-16 Thread Ron Piggott
For a query similar to: SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor' how do I escape the ' for 's?

[PHP-DB] Escaping Characters help needed

2005-09-23 Thread Chris Payne
Hi there everyone, Can any of you see why the below will not insert into my database? Hann Heritage Homes' Fall Circuit entry. Fabulous ranch floorplan w/walkout basement. Stunning great room w/FP, dramatic dining room, den, screened porch. Mullett kitchen with glazed birch cabinets and granite.

Re: [PHP-DB] Escaping Characters help needed

2005-09-23 Thread Micah Stevens
look at: mysql_escape_string(); On Friday 23 September 2005 2:28 pm, Chris Payne wrote: Hi there everyone, Can any of you see why the below will not insert into my database? Hann Heritage Homes' Fall Circuit entry. Fabulous ranch floorplan w/walkout basement. Stunning great room w/FP,

Re: [PHP-DB] Escaping Characters help needed

2005-09-23 Thread Micah Stevens
Just out of curiosity, your method looks like it should work, what's the mysql error message? -Micah On Friday 23 September 2005 2:28 pm, Chris Payne wrote: Hi there everyone, Can any of you see why the below will not insert into my database? Hann Heritage Homes' Fall Circuit entry.

[PHP-DB] escaping line brakes

2002-07-16 Thread Andy
Hi there, I am putting text into a mysql db from a form field. I do include the linebrakes with line2br. Now I would like to create an interface where I could load the text into the form again to edit it. Unfortunatelly it includes some wired chars like \br into the text. How can I get rid of

RE: [PHP-DB] escaping line brakes

2002-07-16 Thread joakim . andersson
From: Andy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 2:45 PM Hi there, I am putting text into a mysql db from a form field. I do include the linebrakes with line2br. Now I would like to create an interface where I could load the text into the form again to edit it.

[PHP-DB] Escaping queries in php using InterBase

2001-08-22 Thread Yves Glodt
Hello, I'm in trouble with my current project which uses Interbase as backend. (php.ini: magic_quotes_sybase = On) When I insert a string containing a ', like Beverly D'Angelo, php saves it with two ' When I insert it with two ', it gets saved with four ' Short: php multiplies all the ' by

Re: [PHP-DB] Escaping queries in php using InterBase

2001-08-22 Thread Patrik Wallstrom
On Wed, 22 Aug 2001, Yves Glodt wrote: Hello, I'm in trouble with my current project which uses Interbase as backend. (php.ini: magic_quotes_sybase = On) When I insert a string containing a ', like Beverly D'Angelo, php saves it with two ' When I insert it with two ', it gets saved with

RE: [PHP-DB] Escaping

2001-07-13 Thread Rankin, Randy
To: Rankin, Randy; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Escaping Please explain the dynamic link . is that in the documentation somewhere? Kne - Original Message - From: Rankin, Randy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 8:18 AM Subject: [PHP-DB

[PHP-DB] Escaping

2001-07-12 Thread Rankin, Randy
Hello, I have a table in a MySQL DB (RH Linux/Apache) with a field called customer_name. Some of the customer names have an ampersand in them (ie; X X Supply). I am performing a select statement on this table to create a sales summary with customer name and total sales. This works fine;

Re: [PHP-DB] Escaping

2001-07-12 Thread Roger Ramirez
When they click on the link what is happening? Is it doing a query in the database for all users with that name? If so you may want to do a str_replace('','\','customer_name') before your query. Basically you just want to add the \ before the ampersand. I haven't tried this but it SHOULD

Re: [PHP-DB] Escaping

2001-07-12 Thread leo g. divinagracia iii
try using the SUBSTR function to check each string for the first char as a . if it does have it, strip and continue the process... Rankin, Randy wrote: Hello, I have a table in a MySQL DB (RH Linux/Apache) with a field called customer_name. Some of the customer names have an ampersand in

Re: [PHP-DB] Escaping

2001-07-12 Thread Ken Sommers
Please explain the dynamic link . is that in the documentation somewhere? Kne - Original Message - From: Rankin, Randy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 8:18 AM Subject: [PHP-DB] Escaping Hello, I have a table in a MySQL DB (RH Linux/Apache

RE: [PHP-DB] Escaping

2001-07-12 Thread Beau Lebens
($customer) . \Customer/a\n; /beau // -Original Message- // From: Ken Sommers [mailto:[EMAIL PROTECTED]] // Sent: Friday, 13 July 2001 11:27 AM // To: Rankin, Randy; [EMAIL PROTECTED] // Subject: Re: [PHP-DB] Escaping // // // Please explain the dynamic link . // is that in the documentation

RE: [PHP-DB] Escaping

2001-07-12 Thread Matthew Loff
I think he just means a hypertext anchor, that contains a string identifying the record. A HREF=fun.php?id=$id -Original Message- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 11:27 PM To: Rankin, Randy; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Escaping