Re: trouble with MySQL 'LIKE' command
| From: | r.gelstharp | Date: | Fri, 04 May 2001 18:28:48 +0000 |
| Subject: | Re: trouble with MySQL 'LIKE' command | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-7294@lists.php.net to get a copy of this message | ||
Done like you recommended with the select....like '%".$var."%' but it still
gives me empty rows of data.
Everytime I try and search for something it returns with 7 rows of data, all
of which are blank. I'm using the basic mysql_num_rows to get the number of
rows of data it retrieves, and I'm using a WHILE($data =
mysql_fetch_array($sql_result)) to output the rows of data.
If it's not the SQL statement, what could be doing this? I ask in case
you've heard this problem mentioned by some thick newbie like meself before.