Picky MySQL query

asp55 · Post by **asp55** » Thu Jul 31, 2003 9:41 am

So I'm putting together a dynamic mysql database manager, and for some reason I'm coming across this little problem for editing or deleting (or simply selecting) an entry with an apostrophe in it.

By simply not specifying the section with the apostrophe everything works, but being that I am attempting to make this dynamic, that obviously isn't really an option in the long run.

Doesn't work

Code: Select all

 DELETE FROM `forum` WHERE `id_datetime` = '20030731050650' AND `forums_main` = '1' AND `subject` = 'test' AND `body` = 'I\'m testing' AND `user_id` = '1' AND `thread_id` = '20030623214620'

works

Code: Select all

 DELETE FROM `forum` WHERE `id_datetime` = '20030731050650' AND `forums_main` = '1' AND `subject` = 'test' AND `user_id` = '1' AND `thread_id` = '20030623214620'

Anyone have any idea's as to how to break it's will and make it work?

Post by **Martin Blank** » Thu Jul 31, 2003 2:13 pm

Are you getting back a particular error if you run this in MySQL?

asp55 · Post by **asp55** » Thu Jul 31, 2003 8:50 pm

Nope, that's what's baffling me about it. The query goes off without a hitch, but doesn't bring up anything. It?s weirding me out.

Post by **Martin Blank** » Thu Jul 31, 2003 10:11 pm

You should get back a number of rows affected. Is it coming back "0 rows" or "1 row" or what?

asp55 · Post by **asp55** » Thu Jul 31, 2003 11:34 pm

it was 0 rows

(note: this is a database manager I was working on building in php)

set it so that it just does a query for the primary key, and now it works...though I'm still a little confused why the original query wasn't effecing the row. It's weird.

Post by **Martin Blank** » Fri Aug 01, 2003 3:55 am

If you're passing the code in PHP, it may be auto-escaping the \ and the ' for you, meaning the database is getting this for a query:

Code: Select all

DELETE FROM `forum` WHERE `id_datetime` = '20030731050650' AND `forums_main` = '1' AND `subject` = 'test' AND `body` = 'I\\\'m testing' AND `user_id` = '1' AND `thread_id` = '20030623214620'

Since you don't have an entry like that, it returns 0 rows.

Unless, of course, you've run that query directly in MySQL, in which case I'm off-base.

Mandor · Post by **Mandor** » Fri Aug 01, 2003 7:13 am

There is absolutly no reason PHP would auto escape the "\". Still if you are using PHP, you can probably make a test based on stripslashes(), but still I don't think it matters really.

Try by replacing the single quotes by double quotes, just to see if the problem comes from the escape of your single quote in the "I'm testing".

Real Life Forums

Picky MySQL query

Picky MySQL query

Who is online