ציטוט:
נכתב במקור על ידי RS324
למה להשתמש ב IN ?
PHP קוד:
$phone = '0505123123';
$address = 'sweet home Canada';
$name = 'myname123'
$db->query_fetch("SELECT * FROM users WHERE phone='$phone' AND username='$name' AND address LIKE '%$address%' ORDER BY userid DESC LIMIT 1 ");
משהו כזה בערך |
בדיוק זה כבר מה שעשיתי...
עשיתי משהו כזה:
PHP קוד:
$query_InstertToSql = "SELECT * FROM search1 WHERE cboGenralPracticeArea LIKE '$cboGenralPracticeArea' AND cboSpecPracticeArea LIKE '$cboSpecPracticeArea' AND cboCity LIKE '$cboCity' AND cboLanguagesSpoken LIKE '$cboLanguagesSpoken' AND cboLawSchool LIKE '$cboLawSchool' AND cboMajorMemberships LIKE '$cboMajorMemberships' AND cboBoardMemberShip LIKE '$cboBoardMemberShip' AND cstreet LIKE '$cstreet' AND cphone LIKE '$cphone' AND cname LIKE '$cname' AND cltdname LIKE '$cltdname' ORDER BY sid DESC";
בכול מקרה תודה.