Search in a specific field

jd57

Can someone tell me how can I set the code to search in only one specific field "Bloom_Name"
I've tried $searchval="Bloom_Name";
Regards JD

//**************** Search ************************************ 
		if(isset($_POST['searchval'])){
			$searchval=$_POST['searchval'];
		}elseif(isset($_GET['searchval'])){
			$searchval=$_GET['searchval'];
		}else{
			$searchval="";
		}

	if (isset($_GET['tablename'])){ 
		$tablename = $_GET['tablename'];
	}

	if((isset($_POST['search'])|| isset($searchval)) && $searchval !=""){ 
		$result=searcht($tablename, $_SESSION['dbname'],  $searchval); 
	}else{	
		//Display All 
		$query = "select * from $tablename"; 
		$result=exequery($query, $tablename, $_SESSION['dbname']);			 
	}

TF_TheMoon

What if the definition of this function searcht()

I suspect you are not passing the WHERE clause in correctly

jd57

I have tried and I get the same results

$query = "select Bloom_Name from $tablename WHERE Bloom_Name = '$BloomName'";

Blulagoon

Can you show us the code for your function searcht() - it might be that the problem is in there somewhere.

Blu

jd57

Here is searcht() function Hope you can help

function searcht($tablename, $dbname, $searchval){ 
	if(! empty($searchval)){ 
		//	$searchval= str_replace(";",' ', $searchval); 
        $result=exequery("Select * from $tablename", $tablename, $dbname);
		//$result=mysql_query("Select * from $tablename"); 
		$num = mysql_num_fields($result); 
		$fields = mysql_list_fields($dbname, $tablename);		 
		$whr="where "; 
		$tok=explode(" ",$searchval); 
		for ($t =0; $t < count($tok); $t++){					 
			for ( $c = 0; $c < $num; $c++){ 
				$fn =mysql_field_name($fields, $c);				 
				$whr .=" $fn like '%$tok[$t]%' or ";													 
			} 
		} 
		$whr=trim(substr_replace($whr, " ", -3));		 
		$query="Select * from $tablename $whr"; 
		$result=exequery($query, $tablename, $dbname); 
		return $result;	 
	}

Weedpacket

jd57 wrote:
$query = "select Bloom_Name from $tablename WHERE Bloom_Name = '$BloomName'";

That will only return the contents of the Bloom_Name field - which is a waste of time because you already know what the bloom name is - and doesn't return anything else. Presumably you're wanting to SELECT the values of some other fields, restricting the records examined to those WHERE Bloom_Name has the desired value.

jd57

I'm a newbie at this, I have many things to learn, all I'm looking for is, that the search will be done in only one field instead of all, the reason for this is because I have duplicate names in other fields.

Weedpacket

Well, someone went for the kitchen-sink approach here 🙂

 for ($t =0; $t < count($tok); $t++){                    

            for ( $c = 0; $c < $num; $c++){
                $fn =mysql_field_name($fields, $c);                

                $whr .=" $fn like '%$tok[$t]%' or ";                                                    

            }
        }

becomes

 for ($t =0; $t < count($tok); $t++){                    

                $whr .=" Bloom_Name like '%$tok[$t]%' or ";                                                    

        }

laserlight

Did you write searcht() and exequery() yourself?

Basically, the answer is very simple:
SELECT colname FROM tablename WHERE colname='$searchval';

But the whole business of searcht() and exequery() confuses the issue.

jd57

Thank You all, it's working great 🙂 🙂