PDA

View Full Version : Query doesn't work?

luker
06-23-2007, 07:21 PM
Whenever a username ($Name) has spaces in it, this query doesn't work.
Content visible to registered users only.
Is there a way to fix this?
Morgan
06-23-2007, 07:59 PM
Check whether the space in $Name is a + or %20 or whatever, and then consider the PHP str_replace (http://www.php.net/manual/en/function.str-replace.php) function.
luker
06-23-2007, 08:09 PM
I took a look at the database and the source and it appears as a space, so I tried this
Content visible to registered users only.
nothing...
Morgan
06-23-2007, 08:40 PM
Content visible to registered users only.
luker
06-23-2007, 10:56 PM
when I view the source, this is what I get
Content visible to registered users only.
Morgan
06-23-2007, 11:12 PM
Check whether 'Jamie Ann' has actually uploaded any files. If so:
Content visible to registered users only.
You need to find where the space is being treated differently.
luker
06-23-2007, 11:39 PM
when I use that, all i get is Jamie Ann
Morgan
06-23-2007, 11:45 PM
Without seeing all of your code, all I can do is guess, so consider getting a programmer to look at your code. Please note though that I'm not available for any freelance work at this time, so I'm sorry, but I won't review your code. If you want to upload your code, not any PhotoPlog code, in the hopes that someone else will look at it, feel free.