Page 1 of 1

search data by filtering

Posted: Sun May 23, 2004 9:29 pm
by merican
hai all again,
I need help to search data in a MYSQL table with different fields. Let say I want to filter by department and by author. I have a search code only search by department. Below is the code:-

Code: Select all

$mysql->Query("SELECT * FROM ffdb_dept WHERE file_dept LIKE '%".$_REQUESTї'department']."%' LIMIT $ffdb->data_bottom,$ffdb->data_top");
Can anyone help me with this. Search data by filtering.
Thank You in advance.

regards,
alfy Merican

Posted: Sun May 23, 2004 10:10 pm
by d3ad1ysp0rk
as in

Code: Select all

ORDER BY desc
or

Code: Select all

ORDER BY asc
??

hi

Posted: Mon May 24, 2004 12:27 am
by merican
hi all..
at last i figure out something by try an errror..it really works! i modified it to this code:-

Code: Select all

$mysql->Query("SELECT * FROM ffdb_files WHERE file_filename LIKE '%".$_REQUESTї'filename']."%' AND author LIKE '%".$_REQUESTї'author']."%' AND author_site LIKE '%".$_REQUESTї'author_site']."%'   LIMIT $ffdb->data_bottom,$ffdb->data_top");
so now, i can search by filename..author and author_site..TQ alll

Best Regards
Alfy