[RESOLVED] Select statment using Like

Dawg

I have written several MySQL statements using PHP, made the connection and retrieved data. But this is the first itme I am using the LIKE operator.

I can use PHPMyAdmin and write the statment and get data (59 rows)
SELECT *FROM tblSA_articlesWHERE article LIKE '%Photo%'

I take that statement and use it in my PHP page and get (0 rows).
($sql = "SELECT * FROM tblSA_articles WHERE 'article' LIKE '%Photo%' "😉

When writing the statement in PHP it does not like quotes around the table name but PHPMyAdmin does. The statement in the PHP needs the single quotes around the column name and the variable.

Eventually the "%Photo%" will be replaced by an input variable.

Any thoughts?

Thanks

rulian

in phpMyAdmin they are actually accents (the one left of the 1 key) rather then a single quote ' but you should get away without using them. echo a mysql_error() after you execute your query, it will probably say 'article' is invalid or not found, it should bearticle`, because other then that your query looks fine

Scriptmaker

Give this format a shot:

$query = "SELECT * from table_name WHERE field_name like \"%$variable%\" "; 
 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults); 
echo $numrows;

Dawg

It appears the `solves the problem. I know this little character as a "TILDA" and is used for accenting letters in words. I only put it around the column name as the variable seems to like the single qoute.

The mysql_error() returned nothing.

I never never knew it had a use in MySQL. I always thought they were single quotes.

Using the escaped double quotes did not work.

Thanks for the info and any further comments on the construction of statements by us relative beginners is greatly appreciated.

Thanks

mpb001

You do not need to use ` unless something is a reserved word like a table called select etc.

Dawg

mpb001 wrote:
You do not need to use ` unless something is a reserved word like a table called select etc.

If that is the case why does the query work when I encapsulate the name of the column article with the Accent and not work when it is not encapsulated or is encapsulated with single quotes?

I am getting confused🙂

Thanks

rulian

in theory
SELECT from mytable
AND
SELECT from mytable
should be identical. However, I find it in good practise to always use to isolate table and column names. I havent found an instance where it's hurt me yet. even in joins I do JOINmytableasBLAHontb1.id=BLAH.id`

Dawg

rulian wrote:
in theory
SELECT from mytable
AND
SELECT from mytable
should be identical. However, I find it in good practise to always use to isolate table and column names. I havent found an instance where it's hurt me yet. even in joins I do JOINmytableasBLAHontb1.id=BLAH.id`

Thanks, that makes tons of sense. I learned something good today.

I like Chick Norris too.