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

[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

 

[hussein1363]

امیدوارم که منظورتون رو درست متوجه شده باشم
اگه ساختار فرمتون به شکل زیر باشه

<form method="POST" action="search.php">
 <p><span lang="fa">نام</span>:<input type="text" name="name" size="20"><br>
 <span lang="fa">نام خانوادگی</span>:<input type="text" name="family" size="20"><span lang="fa"><br>
 شماره نظام</span>:<input type="text" name="drnumber" size="20"><span lang="fa"><br>
 شهرمطب</span>:<input type="text" name="city" size="20"><span lang="fa"><br>
 رشته تخصصی</span>:<span lang="fa"><select size="1" name="takhassos">
 <option>دکترای پزشک عمومی</option>
 <option>متخصص جراحی مغز و اعصاب</option>
 </select></span></p>
 <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

داخل فایل serach.php کوئری شما به شکل زیر است البته نحوه نمایشتون دیگه به خودتون برمی گرده من فقط جستجو رو براتون نوشتم

<?php
$Query="SELECT * FROM doctors WHERE name like '%".$_POST['name']."%' AND family LIKE '%".$_POST['family']."%' AND drnumber LIKE '%".$_POST['drnumber']."%' AND city '%".$_POST['city']."%' AND takhassos LIKE '%".$_POST['takhassos ']."%' ";
mysql_query($Query) or die (mysql_error());
?>