ansaurus

Question

Problem with a mysql query (like) and php

Answer 1

+3 A:

Use single quotes in your LIKE string instead (I believe phpMyAdmin magically converts that to single quotes for you before running the query):

$b = "SELECT Nombre, Link, Img_Pre, Precio, Descripcion, ID, Categoria, Subcategoria FROM Productos WHERE Nombre LIKE '%$a%'";

Make sure you've escaped $a using mysql_real_escape_string() too, because it might be breaking your queries by introducing unescaped quotes!

BoltClock 2010-09-04 11:30:39

what's wrong with double quotes?

Col. Shrapnel 2010-09-04 11:35:39

double quotes under php are used for Literal chars, so `"hey $username"` would convert username into its value, but `'hey $username'` would not.. it would literally print out `$username`. I believe that this is the same with mysql, there a separation of string containers to make it easy for the user to specify what to be parsed, such as escape chars etc.

RobertPitt 2010-09-04 11:42:20

@RobertPitt you are wrong. there is nothing nearly similar in mysql. Both quotes are equal in every way.

Col. Shrapnel 2010-09-04 11:45:06

I should of consulted the docs first. +1

RobertPitt 2010-09-04 11:49:50

@Col. Shrapnel: I don't know, PHP's MySQL extension just acts that way.

BoltClock 2010-09-04 12:38:40

BoltClock nope, MySQL extension acts ether way. should of consulted the docs first as that dude just said.

Col. Shrapnel 2010-09-04 12:47:01

Answer 2

A:

$b = "SELECT Nombre, Link, Img_Pre, Precio, Descripcion, ID, Categoria, Subcategoria 
    FROM Productos WHERE Nombre LIKE \"%"+$a+"%\"";

oneat 2010-09-04 11:31:41

Answer 3

A:

Try:

$b = "SELECT Nombre, Link, Img_Pre, Precio, Descripcion, ID, Categoria, Subcategoria FROM Productos WHERE Nombre LIKE '%$a%'";

Some SQL queries will croak if you don't use apostrophes as the string delimeter

Rowland Shaw 2010-09-04 11:31:43

What queries? Got an example?

Col. Shrapnel 2010-09-04 11:40:21

@Col Depends entirely on the whether you've got ANSI_QUOTES set: http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html#sqlmode_ansi_quotes

Rowland Shaw 2010-09-04 15:51:44

Answer 4

A:

WOW how fast are you guys! Thanks a lot for your help. Finally with your answer I was sure that this part of my code was correct and when Bolt said me that I have to use 'mysql_real_escape_string' I realized that in this variable I didn't use it but what it's more, I used after defining all the query. I change 'mysql_real_escape_string' from all the query to only my variable a and all gone well!

Thanks! :D

Eureka 2010-09-04 12:19:55

That's what I suspected.

Col. Shrapnel 2010-09-04 12:28:09

ansaurus

tags:

views:

answers:

Problem with a mysql query (like) and php

related questions