Ho to Search in Database

[Anon]

Hello All,
for the last few days i have been facing such a perplexing situation and I know that it is a bit foolish to ask this kindda question before you master guys. But anyway sorry for my foolishness..
I want to search a string in our database. This string comes after a multiple selection from a select box. I had written this code but it dosent working
$sa="link like '$location'";
and in query i add $sa after "where $sa"..
and after finding the string i want to print each and every row..

Any help would be appriciable..

Thanx

[Anon]

What database are you using?

[Anon]

Try to put % signs in your search clause:

$is_like_something='something';

select * from table_name where some_field like '%$is_like_something%'

[Anon]

Yeah I put the "%$location%" but it dosent still dosent working. I am using "musql" database.. my code is as follows..
I have put the * where it's giving error.

<?php
if ($course)
{
$sa .= "course like '%$course%' and ";
}
if ($level)
{
$sa .= "level like '%$level%' and ";
}
if ($location)
{
$count=count($location);
for ($i=0; $i<$count; $i++)
{
$sa .=" location like '%location%'";
}
}
$db=mysql_pconnect("localhost") or die("Could not connect to the DB");
mysql_select_db("study",$db) or die("Could not select to the DB");
$sql1 = "select from fetchuniversity where $sa";
$result1=mysql_query($sql1);
error* $row=mysql_fetch_object($result1);
while ($row)
{
echo ("your search result is as follows <br>");
echo (" $row->name, $row->course, $row->level, $row->location, $row->url ");
}
?>