Re: [PHP] Characters causing problems in search strings?

2009-07-17 Thread Bastien Koert
On Thu, Jul 16, 2009 at 5:40 PM, Miller, Terion wrote: > My little browse /search restaurant project is coming along, but I just > noticed that any restaurant with a &, () or # in the name like say for > example Arby's Store #12 ...will not return results... Yet if a name has a / > or a - it's not

[PHP] Characters causing problems in search strings?

2009-07-16 Thread Miller, Terion
My little browse /search restaurant project is coming along, but I just noticed that any restaurant with a &, () or # in the name like say for example Arby's Store #12 ...will not return results... Yet if a name has a / or a - it's not a problem... 1. why is this and how do and where do I escape th

Re: [PHP] Characters

2003-06-10 Thread Jason Wong
On Wednesday 11 June 2003 04:28, Steve Marquez wrote: > I am inserting a file via a PHP form. It works great, however, if there is > a word that has quotes in it, then it does not work at all. > > Is there a way to make it so that MySQL will receive a word with "quotes?" mysql_escape_string() --

[PHP] Characters

2003-06-10 Thread Steve Marquez
I am inserting a file via a PHP form. It works great, however, if there is a word that has quotes in it, then it does not work at all. Is there a way to make it so that MySQL will receive a word with "quotes?" Thanks -Steve Marquez [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php

Re: [PHP] Characters counting

2001-04-19 Thread elias
You can use MySql's LEFT() or even substring() example: SELECT substring(address,1, 20) as _addr FROM tablename and you will have to look for field "_addr" in mysql results. -elias http://www.kameelah.org/eassoft ""Jorn van Eck"" <[EMAIL PROTECTED]> wrote in message 9bkpd8$r77$[EMAIL PROTECTED

Re: [PHP] Characters counting

2001-04-18 Thread Joe Stump
look into the substr() function in PHP --Joe On Tue, Apr 18, 2000 at 09:23:39PM +0200, Jorn van Eck wrote: > Hi there, > > Does someone know how to display for example150 characters from a $ set by > MySQL? > -- > Jorn van Eck > Student Information Engineering > Almere > Tel: +31 614430902 > E-

Re: [PHP] Characters counting

2001-04-18 Thread Johannes Janson
Hi, to get the first 150 chars of a mysql filed do this: SELECT LEFT(YourField, '150') FROM YourTable WHERE YourCondition=true; This does it in MySQL and for PHP follow the mentioned substr-method. cheers Johannes ""Jorn van Eck"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 9bkpd8$r77$[EMAIL PRO

RE: [PHP] Characters counting

2001-04-18 Thread Jack Dempsey
about that... -jack -Original Message- From: Jorn van Eck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 18, 2000 3:24 PM To: [EMAIL PROTECTED] Subject: [PHP] Characters counting Hi there, Does someone know how to display for example150 characters from a $ set by MySQL? -- Jorn van

[PHP] Characters counting

2001-04-18 Thread Jorn van Eck
Hi there, Does someone know how to display for example150 characters from a $ set by MySQL? -- Jorn van Eck Student Information Engineering Almere Tel: +31 614430902 E-mail: [EMAIL PROTECTED] Website: http://www.iie.nl/~eck13 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e