not that simple query for me

[vlada]

probably simple problem, but it rape my brain.

table name is "oglasi", 17 fields, one of them is field called "predmet"

in that field in few raws there is value "Bas"

simple query

SELECT * FROM `oglasi` WHERE predmet = Bas

mysql answers:

Unknown column 'Bas' in 'where clause'

what's going on?

thanks in advance

 

[PFMaBiSmAd]

String data must be enclosed in single-quotes so that it is treated as a string and not as a mysql identifier or keyword. Also, back-tacks `` are mysql specific and should be avoided (there is nothing in your query that needs them.)

 

 SELECT * FROM oglasi WHERE predmet = 'Bas'

[vlada]

thank you very much

that's it

i put back-tacks by mistake

i didn't even saw that

i'm just a beginner in this

thnx again