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
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
5 matches
Mail list logo
