جستجو در ديتابيس(نياز به كمك فوري يكي از دوستان

[you3f]

سلام دوستان عزيز من يه يه مشكل برخوردم موندم چيكار كنم اگه يكي از دوستان لطف كنه يه كمك خيلي فوري ميخوام خيلي ضروريه
من يه سورس ساده جستجوي ديتابيس ميخواستم منتها جستجو با چند فيلد
نحوه كار اسكريپت رو هم تو اين فايل كوچيك كه تو اين آدرس گذاشتم كاملا توضيح دادم
http://www.azar-teb.org/tozihesearch.doc
اگه يكي از دوستان يه لطف كنه اين اسكريپت رو برام بنويسه لطف بزرگي بهم كرده يا لااقل يه راهنمايي كوچيك كنه بگه ميشه واسه اين جستجوي چند فيلدي كه گفتم تو SELECT رو اينجوري نوشت

SELECT * FROM doctors WHERE
name LIKE ‘%”$name”%’ AND family LIKE ‘%”$family”%’ AND drnumber='drnumber' AND takhassos LIKE ‘%”$takhassos”%’ AND city LIKE ‘%”$city”%’ OR

name LIKE ‘%”$name”%’ AND family LIKE ‘%”$family”%’ AND drnumber='drnumber' AND city LIKE ‘%”$city”%’ OR
name LIKE ‘%”$name”%’ AND drnumber='drnumber AND' takhassos LIKE ‘%”$takhassos”%’ AND city LIKE ‘%”$city”%’ OR
name LIKE ‘%”$name”%’ AND family LIKE ‘%”$family”%’ AND drnumber='drnumber' AND takhassos LIKE ‘%”$takhassos”%’ OR
name LIKE ‘%”$name”%’ AND family LIKE ‘%”$family”%’ AND takhassos LIKE ‘%”$takhassos”%’ AND city LIKE ‘%”$city”%’ OR
family ‘%”$family”%’ AND drnumber='drnumber' AND takhassos LIKE ‘%”$takhassos”%’ AND city LIKE ‘%”$city”%’ OR

name LIKE ‘%”$name”%’ AND family LIKE ‘%”$family”%’ AND drnumber='drnumber' OR
name LIKE ‘%”$name”%’ AND family LIKE ‘%”$family”%’ AND takhassos LIKE ‘%”$takhassos”%’ OR
name LIKE ‘%”$name”%’ AND family LIKE ‘%”$family”%’ AND city LIKE ‘%”$city”%’ OR
name LIKE ‘%”$name”%’ AND drnumber='drnumber' AND takhassos LIKE ‘%”$takhassos”%’ OR
name LIKE ‘%”$name”%’ AND drnumber='drnumber' AND city LIKE ‘%”$city”%’ OR
name LIKE ‘%”$name”%’ AND takhassos LIKE ‘%”$takhassos”%’ AND city LIKE ‘%”$city”%’ OR
family LIKE ‘%”$family”%’ AND drnumber='drnumber' AND takhassos LIKE ‘%”$takhassos”%’ OR
family LIKE ‘%”$family”%’ AND drnumber='drnumber' AND city LIKE ‘%”$city”%’ OR
family LIKE ‘%”$family”%’ AND takhassos LIKE ‘%”$takhassos”%’ AND city LIKE ‘%”$city”%’ OR
drnumber='drnumber AND' takhassos LIKE ‘%”$takhassos”%’ AND city LIKE ‘%”$city”%’ OR



name LIKE ‘%”$name”%’ AND family LIKE ‘%”$family”%’ OR
name LIKE ‘%”$name”%’ AND drnumber='drnumber' OR
name LIKE ‘%”$name”%’ AND takhassos LIKE ‘%”$takhassos”%’ OR
name LIKE ‘%”$name”%’ AND city LIKE ‘%”$city”%’ OR
family LIKE ‘%”$family”%’ AND drnumber='drnumber' OR
family LIKE ‘%”$family”%’ AND takhassos LIKE ‘%”$takhassos”%’ OR
family LIKE ‘%”$family”%’ AND city LIKE ‘%”$city”%’ OR
drnumber='drnumber' AND takhassos LIKE ‘%”$takhassos”%’ OR
drnumber='drnumber' AND city LIKE ‘%”$city”%’ OR
takhassos LIKE ‘%”$takhassos”%’ AND city LIKE ‘%”$city”%’ OR
name LIKE ‘%”$name”%’ OR
family LIKE ‘%”$family”%’ OR
drnumber='drnumber' OR
takhassos LIKE ‘%”$takhassos”%’ OR
city LIKE ‘%”$city”%’ OR