Re: [PHP] Help w/passing a search parameter that includes space and ,

2002-03-15 Thread Jason Wong

On Saturday 16 March 2002 00:38, Jack Sasportas wrote:
> I have never passed a search value with a space or a comma "," in it,
> but here is the first time.
> What happens is that IE puts in the space and takes the whole value as
> the parameter and correctly finds the result we are looking for from the
> search request, but in Netscape it only sees up to where there is a
> space or where there is a comma.
> Here is how the search value looks from the command line in the browser
>
> display_products.php?search_value=Toilet Tissue,  2-Ply
>
> Within the application it returns there is no match for Toilet which
> basically tells me that php thinks that's the end of the string being
> passed to it.
> Any ideas on how I should get around this ?
>
> This is what the db search string looks like:
>
> $db_result = mysql_query("select * from $db_tablename where
> category='$value'");

Well the truth is that you're not supposed to send spaces via the URL. 

Use urlencode() & it's sibling, to make your parameters URL friendly.


-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk

/*
Two sure ways to tell a REALLY sexy man; the first is, he has a bad memory.
I forget the second.
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Help w/passing a search parameter that includes space and ,

2002-03-15 Thread Jack Sasportas

I have never passed a search value with a space or a comma "," in it,
but here is the first time.
What happens is that IE puts in the space and takes the whole value as
the parameter and correctly finds the result we are looking for from the
search request, but in Netscape it only sees up to where there is a
space or where there is a comma.
Here is how the search value looks from the command line in the browser

display_products.php?search_value=Toilet Tissue,  2-Ply

Within the application it returns there is no match for Toilet which
basically tells me that php thinks that's the end of the string being
passed to it. 
Any ideas on how I should get around this ?

This is what the db search string looks like:

$db_result = mysql_query("select * from $db_tablename where
category='$value'");


Thanks !
___
Jack Sasportas

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php