mysql select query after adding slashes to input

From: 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

« previous php.db (#19026) next »