How to search for a strings

[murushanmugham]

Hello

I have a table with a field name as course and another as subject

the field contains data like this

Record 1
Course='M.D.-PHARMACY'
Subject='APPLIED SCIENCES'

Record 2
Course='M.S.-GENERAL SURGERY'
Subject='APPLIED BASIC SCIENCE'

I use the following

select * from tablename where fname='".$xcourse."' and subject='".$xsub."' order by year desc;


Where I have a course with two words ie. 'M.S.-GENERAL SURGERY' , no records are selected.

Whereas for course ='M.D.-PHARMACY' works fine.

How do I solve this please help

 

[r937]

try your query in mysql, i.e. outside of your scripting language

r937.com | rudy.ca

 

[murushanmugham]

It wworks fine in mysql but when used in a script does not work.

 

[r937]

then perhaps you might start a new thread in the php forum?

r937.com | rudy.ca