Re: Yet more strings

When I have exact string matches fail where I don't expect them, and using a LIKE fixes it, the very first thing I check for is embedded whitespace in the data. "foo " and "foo" and " foo " are not the same. If this is the case then IMHO the best solution is to fix the data in the database, but barring that you can probably use the TRIM() function in your where clause. (note: the MySQL docs show using trim in the output, not in the where clause so I won't swear that its possible, but it should be) Regards, Gary ""Mick Lloyd"" <mjl@consultingrooms.com> wrote in message news:00c001c0b1ea$54a5f5c0$5c0083ca@oemcomputer... > CC's suggestion of using mysql_num_rows helped to clarify the problem rather > than find a solution! The problem is with mysql not PHP. When I use: > > $resultp = mysql_query("select Primaryid from primarycodes where Code = > '".$row[Primaryexpertise]."'") or die (mysql_error()); > > it doesn't return a resource id#, ie the query fails. mysql_num_rows returns > 0. > > Using: > > $resultp = mysql_query("select Primaryid from primarycodes where Code LIKE > '%$row[Primaryexpertise]%'") or die (mysql_error()); > > it works, mysql_num_rows returns 1. > > I have also checked the string length of $row[Primaryexpertise] (the value > of which is Biology for example) and it shows that there are no "hidden" > characters in the field value (ie strlen returns 7). > > Running all this at the mysql shell (is that the word?) results in the same > errors. > > The row values are Primaryid (8) and Code (Biology). > > mysql>select Primaryid,Code from primarycodes where Code like '%Biology%'; > \\returns the correct values > > mysql>select Primaryid,Code from primarycodes where Primaryid = 8; \\returns > the correct values > > mysql>select Primaryid,Code from primarycodes where Code = 'Biology'; > \\returns Empty set > > I'm no expert (obviously) but something seems odd here. > Regards > > Mick Lloyd > mjl@consultingrooms.com > Tel: +44 (0)1684 560224 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >