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