can any one please help create a sql script that searches based on atleast 10 conditions
with where ... and clause
$query_rsearch = "SELECT id, job, description, location, cname, ctype, sal, exp, industry, postd FROM jobs WHERE job like'%$k%' and location like '%$l%' and ctype like '%$i%'
when i use more that 3 conditions to the scipt it doesnt work
just a work around, because when i query with php and i have so many "and"s in "where" it is working...
so instead depend whole in sql, why don't you just query it simply until what "where..and" is working and put the result in an array
and doing some filtering under the programming if-es and put the real value in the new array or other to be displayed/printed...
of course this not the solver, but just a work around, it need more cpu resources/time, but it will work showing the result...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.