A
Anonymous
Guest
Is it possible that the description of those unwanted records contains 240?
I don't see any errors in the query...
Coditor
I don't see any errors in the query...
Coditor
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anonymous
Guest
First use this query
select * from document where title = '240 Volt Lighting and Distribution'
and check the result and then move ahead...
select * from document where title = '240 Volt Lighting and Distribution'
and check the result and then move ahead...
A
Anonymous
Guest
can you try it like this please. i think it is going to solve your problem.
Code:
$sql =Select * from document where (title like '%".$descrip."%' or descrip like '%".$descrip."%') and type !='' and (status='Active' or status='obsolete')
$result_qr=mysql_query($sql);
$result = mysql_result ($result_qr,0,"field name");
A
Anonymous
Guest
Please post some more code and use the [ code ] tags. I'm really curious what's happening in the else of your code... I'm wondering if that's where it selects the fields for a certain type...
Coditor
Coditor
A
Anonymous
Guest
Please edit your post above to make it readable. Use the
Code:
tags and indentations... This is impossible to read and I don't feel like editting it myself 8)
Coditor