Re: Yet more strings

Gary Thanks for the advice. I had checked the string length to make sure there were no "hidden" spaces (which there aren't in the specific field I am selecting) and have now tried trim() but to no avail. Still fiddling with it! Regards Mick Lloyd mjl@consultingrooms.com Tel: +44 (0)1684 560224 ----- Original Message ----- From: Gary Huntress <ghuntress@mediaone.net> To: <php-db@lists.php.net> Sent: Wednesday, March 21, 2001 12:45 PM Subject: Re: [PHP-DB] 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 > > > > > > -- > 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 >