new line characters problem

[mfacer]

I've got a problem with my code and the "\r" line return. THe code works perfectly on the unix server "online" but off line on my Windows XP it wont work - as the SQL looks up a value, but it needs to add a "\r" to actually work... eg:

$sql = "SELECT * FROM table WHERE id='$id'";

it works online perfectly... but not offline.... it returns 0 rows... where as when I change it to

$sql = "SELECT * FROM table WHERE id='$id\r'";

it works fine..... is there any setting in XP to do an sql search without looking for extra characters??

thanks for any info...

[RossC0]

Unusual - It shouldn't make any difference what so ever online or off.

What is the query without the php ? i.e. the actual query used by mysql ?

[mfacer]

the actual SQL would look like

SELECT * FROM table WHERE serviceLineID = 'FA' AND organisation='demo'

when I type it directly in to SQL it doesnt work - yet when I do the following, it does...

SELECT * FROM table WHERE serviceLineID = 'FA\r' AND organisation='demo'

whereas through phpmyadmin online, the top SQL statement works......!

[xblue]

My first question would be what data type it is. I'd usually expect numeric type for ids, but those an the other hand should not even accept carriage returns when the data is inserted.

Then, second: how does the data get into the database? I could imagine ways how leftover carriage returns end up in text fields, but this would be wild guesses at this point.

[RossC0]

Yeap - is the data clean?

This suggests that it isn't and has extra (non-visible) characters in it..