To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 07 January 2005 03:25, Jason Walker wrote:
> Graeme - you were moving in the right direction. Since the
> data in the field
> is varchar(250), the only thing that changes is the fact that the last
> number is 3 digits. Other page queries were also affected
> with 4 x 2 digit
> numbers in the category field (eg. '37 48 49 52').
>
> By adding '%' between each number and using 'LIKE' as opposed
> to '=', the
> queries through PHP return the correct value.
>
> I think is very strange as 3x numbers work fine when using
> spaces (' ')
> between each criteria (as in '37 48 53').
>
> The change would look something like:
>
> SELECT description from cpProducts where category like '39%47%48%172'
That's not a good idea, as it would also match entries like:
391 247 48 172
39 147 148 172
395 347 1486 1172
etc.
I think you really need to find out exactly what's in those failing records,
and why it's not matching your query.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
