Hello,

Recently i have noticed that it is impossible to look up certain records. I want to look them up by the field 'model'. This contains numbers like 504010 or 55822S.

Certain numbers are found, others are not (however they are there!). It looks to happen random. When i go to phpmyadmin, click the search tab and enter my number behind the "model" field, it returns also 0 records. However when i check the explore tab, the number i just entered is there. So why is it not found? I checked and there are no spaces or something like that.

The only thing that is consistent (at least i think so), is that in the explore tab in phpmyadmin, the numbers that are found are aligned to the top of the cell, the numbers that are not found are aligned to the bottom of the cell. Does this ring a bell?

Thanks!

Matt

hi killerwhale65,

what type do you use for 'model'?
if it's an int you might have problems with numbers starting with 0,
if it's a string you maybe can't compare via = easy.

i think it would be best if you would post the mysql structure and your query too.

mfg akratellio

hello,

model is a varchar(10) because it can contain a letter as well.

my query is: SELECT aantal FROM backorder where model='".$model."'"

But like i said, its the same when i use the search function of phpmyadmin, and enter the model-number next to 'model' (tried both LIKE and = without luck).

Thanks!

ok i think i have discovered something:

When i export the table, i notice some model numbers like '123456' and others like '\n123456'.

Solved with this query:

UPDATE `backorder` SET `model`=replace(`model`, '\n', '');

Now i only need to figure out how the \n got in there.

hi,

'\n' oftenoccurs when you get input via forms, namely textareas.
Since you don't escape inputs by using nl2br or something all line breaks will be '\n'

mfg akratellio