php sql multiple search

Question

I want to write a php code that can search for multiple keywords separated by a column. Currently my code is working accurately for a particular single keyword. Also; what changes should i make in the SQL table?

<?php
include('db.php');
if($_POST)
{
$q=$_POST['searchword'];
$sql_res = mysql_query("SELECT tag_id, tag_name FROM ttl_tags WHERE tag_name like '%$q%' ORDER BY tag_id LIMIT 5");
while($row=mysql_fetch_array($sql_res))
{
$tagid=$row['tag_id'];
$tagname=$row['tag_name'];
$re_tagname='<b>'.$q.'</b>';
$final_tagname = str_ireplace($q, $re_tagname, $tagname);

?>

and what is the expected max size of ttl_tags? In number of different tags OR number of total rows? (more or less...) — Sebas
– Sebas, Commented Jun 12, 2012 at 14:12
max. size of ttl_tags will be three. ttl_id is an id given to ttl_tags.. eg: "1";"blue"==> ttl_id=1 & ttl_tags=blue. The user will search for key-words aka ttl_tags — xan
– xan, Commented Jun 12, 2012 at 14:15

manurajhada · Accepted Answer · 2012-06-12 15:02:28Z

1

If I am reading your question right, you want to search for multiple keywords in a single column? If so you can do:

 $sql_res = mysql_query("SELECT tag_id, tag_name FROM ttl_tags 
            WHERE tag_name like '%$q%' OR tag_name like 'ANOTHER_PARAMETER'  
            ORDER BY tag_id LIMIT 5");

You can put as many "OR"s that you want.

edited Jun 12, 2012 at 15:02

manurajhada

5,4004 gold badges28 silver badges43 bronze badges

answered Jun 12, 2012 at 14:04

WhoaItsAFactorial

3,5484 gold badges31 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

php sql multiple search

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related