PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
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:-
$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