[RESOLVED] Need help urgently

[n_baswa]

Hi frends,

I've this problem, which i don't know how to fix it.

I've completed my project and it was working perfectly, but just now i came up with this problem....

when we r trying to add any record which has a # character in it....the program is not working as it should.

can anyone pls let me know why is this happening and how do i fix it?

Thanks.

[laserlight]

You need to provide more details. The simplest and smallest script that demonstrates the problem is one way.

[nemonoman]

In mysql the # character is used to indicate a comment. Using a # will comment out a line

SELECT *
FROM mytable
WHERE x=y

also want y=1

AND y=1

If your new server has collapsed these lines before processing

SELECT * FROM mytable WHERE x=y # also want y=1 AND y=1
the second part of the WHERE clause will not be applied

So somehow or other, your # in submitted text is being viewed as a comment. I'm with Laserlight: show us the query!

[n_baswa]

thanks guys.....i was able to fix it.

CGRAZ - I'm sorry, i'll not post in 2 threads...Actually i had to fix the problem as soon as possible and so i did it....anyways, will not repeat it.

[bogu]

Don`t forget to mark this thread RESOLVED!