search help code rewite

[winracer]

working on the search and can't get it to work. I am trying

line 63 on index.php what I am tring to do is have is search by name or description


   $_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `description` like '%%$search%%' OR 'name' like '%%$search%%' AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",

thoughs?
     

[hilflo]

And it don't work ?

[hilflo]

This code work for me

Code: [Select]

$search = $_POST['searching'];
$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `name` like '%%$search%%' OR`description` like '%%$search%%' AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",
            SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());

[winracer]

This code work for me

Code: [Select]

$search = $_POST['searching'];
$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `name` like '%%$search%%' OR`description` like '%%$search%%' AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",
            SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());

yes that will work for me to but I want to search the name and the description fileds not just name. I have read and it says to use the or, but I can not get it to work.

Code: [Select]

  $_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `description` like '%%$search%%' OR 'name' like '%%$search%%' AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",



thanks

[hilflo]

This code work for me

Code: [Select]

$search = $_POST['searching'];
$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE [b]`name` like '%%$search%%' OR`description` like '%%$search%%'[/b] AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",
            SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());

yes that will work for me to but I want to search the name and the description fileds not just name. I have read and it says to use the or, but I can not get it to work.

Code: [Select]

  $_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `description` like '%%$search%%' OR 'name' like '%%$search%%' AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",



thanks

It search if the name or the description is like the search.
If you want to search where the name and the description is like the search (I don't think thats a good way to search like that)
Try

Code: [Select]

$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE (`description` like '%%$search%%' AND 'name' like '%%$search%%') AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",

[winracer]

This code work for me

Code: [Select]

$search = $_POST['searching'];
$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE [b]`name` like '%%$search%%' OR`description` like '%%$search%%'[/b] AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",
            SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());

yes that will work for me to but I want to search the name and the description fileds not just name. I have read and it says to use the or, but I can not get it to work.

Code: [Select]

  $_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `description` like '%%$search%%' OR 'name' like '%%$search%%' AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",



thanks

It search if the name or the description is like the search.
If you want to search where the name and the description is like the search (I don't think thats a good way to search like that)
Try

Code: [Select]

$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE (`description` like '%%$search%%' AND 'name' like '%%$search%%') AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",

yes I want the "or" if search is like name or description the return something. I don't want the "and" I think it is a bas idea to do the "and"


i was trying to fix so that the description would be search too.

thanks

[hilflo]

Use the fist code , it search in description too

[winracer]

thanks I got it I used

Code: [Select]

$search = $_POST[searching];
$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `name` like '%%$search%%' OR`description` like '%%$search%%' OR`creator` like '%%$search%%'AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",
SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());




and it works when you search, you search  name  or description or creator
for the search word...

thanks hilflo for you help

can view at http://www.myfunnypets.com/30/index.php