Addslashes / DB Sort
| From: | Ed Lazor | Date: | Mon, 27 Sep 2004 18:49:42 +0000 |
| Subject: | Addslashes / DB Sort | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36429@lists.php.net to get a copy of this message | ||
PHP / MySQL
I'm using PHP to retrieve user input and store it in MySQL. PHP's
addslashes function is used on data going into the database and PHP's
stripslashes function is being used on data coming from the database. This
is allowing me to store and retrieve data with no problems, but it's causing
problems when trying to sort data. In particular, data with double or
single quotes is getting escaped, which changes it's position in the sort.
For example, without using addslashes, I can sort by Title and end up with
the following results:
'Pizza' For Techies
Drinking Beer The OOP Way
The World According To Linus
But. if I use addslashes and try to sort by Title, I end up with:
Drinking Beer The OOP Way
The World According To Linus
\'Pizza\' For Techies
Is there a way to account for this?
Thanks,
Ed