PDA

View Full Version : Query doesn't work?


luker
06-23-2007, 06: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, 06: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, 07: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, 07:40 PM
Content visible to registered users only.

luker
06-23-2007, 09:56 PM
when I view the source, this is what I get
Content visible to registered users only.

Morgan
06-23-2007, 10: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, 10:39 PM
when I use that, all i get is Jamie Ann

Morgan
06-23-2007, 10: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.