select query

Hi there
Firstly I would recommend you seperate the code and species into different fields.
otherwise it will take more coding, and take longer to process.

However here is some code that should work:

<?PHP

$conn = ''; //connection info
$input = $_POST['input']; //the users input
@mysql_select_db('database');
$sql_input = mysql_real_escape_string($input);//sanitize input
$sql = "SELECT * FROM table_name WHERE name LIKE '%$sql_input%'";
//we query with the %LIKE% so as to slightly reduce databse consumption for next event
$query = @mysql_query($sql,$conn); //execute the query
$result = array(); //prepare the array
while($row = @mysql_fetch_assoc($query)){ //loop through the table
	$name = explode('_',$row['name']); //split the result where the underscore is
	$key = $name[0]; //the explode array starts at 0 for first found
	$species = $name[1]; // the species
	if(strpos($key,$input)){ //detect if the input is in the returned key
		$result[] = $row['name']; //add row to result
	}
}
//now you can loop through results

foreach($result as $output){
	echo $output.'<br />';
}
?>

sorry... i have a correction in my question...

actually i need to display..the entire row...matching the keyword..

now how will be the query??

Just output the row as the query is running

<?PHP

$conn = ''; //connection info
$input = $_POST['input']; //the users input
@mysql_select_db('database');
$sql_input = mysql_real_escape_string($input);//sanitize input
$sql = "SELECT * FROM table_name WHERE name LIKE '%$sql_input%'";
//we query with the %LIKE% so as to slightly reduce databse consumption for next event
$query = @mysql_query($sql,$conn); //execute the query
while($row = @mysql_fetch_assoc($query)){ //loop through the table
	$name = explode('_',$row['name']); //split the result where the underscore is
	$key = $name[0]; //the explode array starts at 0 for first found
	$species = $name[1]; // the species
	if(strpos($key,$input)){ //detect if the input is in the returned key
		echo $row['id'].' - '.$row['name'];
	}
}
?>

Just output the row as the query is running

<?PHP

$conn = ''; //connection info
$input = $_POST['input']; //the users input
@mysql_select_db('database');
$sql_input = mysql_real_escape_string($input);//sanitize input
$sql = "SELECT * FROM table_name WHERE name LIKE '%$sql_input%'";
//we query with the %LIKE% so as to slightly reduce databse consumption for next event
$query = @mysql_query($sql,$conn); //execute the query
while($row = @mysql_fetch_assoc($query)){ //loop through the table
	$name = explode('_',$row['name']); //split the result where the underscore is
	$key = $name[0]; //the explode array starts at 0 for first found
	$species = $name[1]; // the species
	if(strpos($key,$input)){ //detect if the input is in the returned key
		echo $row['id'].' - '.$row['name'];
	}
}
?>

thanks!!

No worries.

Remember if thread is solved to mark as solved :D