By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,719 Members | 1,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,719 IT Pros & Developers. It's quick & easy.

%20 char disables query

P: n/a
hi all,

I have a site where a user can enter text (newspost). I recently discovered
that when %20 is entered the text is properly inserted in the database
(INSERT) but isn't shown on the page isn't shown on the page (SELECT).

The text is shown via printf(nl2br(stripslashes($myrow[1]))); where myrow[1]
is the text containing the %20 . Someone knows whats goin on?

Regards
Stijn
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

Stijn Goris wrote (in part):
hi all,

I have a site where a user can enter text (newspost). I recently discovered that when %20 is entered the text is properly inserted in the database (INSERT) but isn't shown on the page isn't shown on the page (SELECT).
The text is shown via printf(nl2br(stripslashes($myrow[1]))); where myrow[1] is the text containing the %20 . Someone knows whats goin on?


The string '%20' is the urlencoded value for a space character. If
you're not enclosing your value in quotes, then the statement would
include the entire string.
To really help you, we have to see more of your code.

Ken

Jul 17 '05 #2

P: n/a

Stijn Goris wrote (in part):
hi all,

I have a site where a user can enter text (newspost). I recently discovered that when %20 is entered the text is properly inserted in the database (INSERT) but isn't shown on the page isn't shown on the page (SELECT).
The text is shown via printf(nl2br(stripslashes($myrow[1]))); where myrow[1] is the text containing the %20 . Someone knows whats goin on?


The string '%20' is the urlencoded value for a space character. If
you're not enclosing your value in quotes, then the statement would
include the entire string.
To really help you, we have to see more of your code.

Ken

Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.