At 4:06 AM -0700 15/4/02, Thomas Edison Jr. wrote:
>I have a table with a column vProName, which
>let's say, contains a record "Basket Ball Game".
>Now what i want is that if someone searches for "Game"
>or "Ball", even then this record should appear.
Either "select * from ThatTable where vProNa
Check out the MySQL page at
http://www.mysql.com/doc/F/u/Fulltext_Search.html. This page talks about
doing full-text searches through your data. Then you can implement the
queries using PHP scripts to perform the searches.. It works super smooth..
You do have to create an index of any column you w
I'm working on a search program that searches on a
mySQL DB and gives back results.
I have a table with a column vProName, which
let's say, contains a record "Basket Ball Game".
Now what i want is that if someone searches for "Game"
or "Ball", even then this record should appear.
Could someone
Yes, it's easy and you already have at least one answer.
If you are going to be doing any database programming, a basic familiarity
with SQL (Structured Query Language) and relational databases is pretty
essential. A book like "SQL for Dummies" is an excellent place to start,
you could probabl
Hey,
Simple solution:
" . stripslashes(htmlentities($name)) . "\n\n" .
stripslashes(htmlentities($description)) . "\n";
}
?>
James.
""YoBro"" <[EMAIL PROTECTED]> wrote in message
9eg0jl$5ac$[EMAIL PROTECTED]">news:9eg0jl$5ac$[EMAIL PROTECTED]...
> Hi,
>
> Any ideas, or any code that will allo
Try this sql statement:
// search for the keyword in NAME or DESCRIPION..
// using the wildcard '%'.
$sql="select * from TABLE_NAME where Name='%search_query%'
OR Description='%search_query%'";
$result=mysql_query($sql) or die ("blah, blah, blah");
...more php codes...see php manual for
Hi,
Any ideas, or any code that will allow a search of specific keywords in a
mysql database.
Feilds in a Table called:
Name
Description
What I am after is if somebody types the word 'hammer', then I want it to
return the results in a list if the word hammer is picked up under the name
of descr
7 matches
Mail list logo
