Topic awaiting preservation: mysql problem.. (Page 1 of 1)

here the syntax is okk...but the code does not get any value....is there any problem in the LIKE ?help...

code
_____________________________________________________________________
user = mysql_query("SELECT Fname,Lname,
Tel,address,level,cityname,subj
FROM detail,city,subject
WHERE detail.AID=city.AID
AND city.AID=subject.AID AND cityname='$cityname' AND subj LIKE '$subjectid' ");

shalvi: If you are taking data from multiple tables you should specify the table names like detail.FName, etc.

___________________
Emps

The Emperor dot org

actually, emps that's wrong: You only have to specify them when their ambigious.

Your problem, shalvi, is that LIKE 'something' works like = 'something'. You'll need to add placeholders (usally % - any character - any number of times, or no charater), either at the beginning or at the end, or both.

The manual would've told you.