search data by filtering
Posted: Sun May 23, 2004 9:29 pm
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:-
Can anyone help me with this. Search data by filtering.
Thank You in advance.
regards,
alfy Merican
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");Thank You in advance.
regards,
alfy Merican