Php removes part of string

Question

I have this simple string variable:

$query="SELECT * FROM striscie AS previous, striscie AS current WHERE previous.linea=current.linea AND current.ident=$striscia AND previous.position<current.position AND previous.position>current.position-$stops";

yet, when I echo or use it, it turns to:

SELECT * FROM striscie AS previous, striscie AS current
WHERE previous.linea=current.linea AND current.ident=897524 AND previous.positioncurrent.position-3
SELECT * FROM striscie AS previous, striscie AS current
WHERE previous.linea=current.linea AND current.ident=920173 AND previous.positioncurrent.position-2

By deleting the whole part of the string. I tried restarting Apache to no avail. What might it be?

some charachter inside php vars ($stops is an example) do cut the string maybe — Marco Mura
– Marco Mura, Commented Dec 16, 2014 at 13:57
My problem is that not only the print sees the string like this, but also sql treats it strangely. I count the number of results but it does not find them, and not being able to see the output string I do not know where the problem might lie. — Fabrizio Bartolomucci
– Fabrizio Bartolomucci, Commented Dec 16, 2014 at 15:11
I managed to fix it blindly, sure it is strange how it mangles the strings. — Fabrizio Bartolomucci
– Fabrizio Bartolomucci, Commented Dec 16, 2014 at 16:18

Niet the Dark Absol · Accepted Answer · 2014-12-16 13:57:35Z

8

< is being treated as HTML by the browser. Don't blindly output stuff like that.

answered Dec 16, 2014 at 13:57

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Php removes part of string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related