mysql select query after adding slashes to input
| From: | CJ | Date: | Tue, 07 May 2002 23:22:40 +0000 |
| Subject: | mysql select query after adding slashes to input | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19026@lists.php.net to get a copy of this message | ||
the contents of the the table is as follows
+-------+---------------+---------------+-----+-------------+------------+--
--------+--------+
| calid | name | stage_name | sex | zodiac_sign |
yrs_involved | yrs_finals | tentid |
+-------+---------------+---------------+-----+-------------+------------+--
--------+--------+
| 45 | Test\'cal\"\" | Test\'cal\"\" | M |
1
| 0 | 0 | 1 |
+-------+---------------+---------------+-----+-------------+------------+--
--------+--------+
i used the php function addslashes() on the data before adding it to the
database.
when i run a query as follows:
mysql> select * from cal where stage_name=' Test\'cal\"\" ';
i get no results.
any suggestions? really need help urgently.
thanks