|All requests||>||Sql database advanced search||>||Request new recommendation||>||Featured requests||>||No recommendations|
by morad mokhtar - 5 years ago (2017-06-27)
I need to search in Sql database by more than two option. example the database contain 6 column (id, firstname, lastname, date, describe, jop) and I need to search by first column (id) than by third column (lastname) and by six column (jop), I need if three option selected the show the result or if any option select show the result from database
hi.I think you could do what you want with a simple select query on the database so this package should be very usefull for it can connect to many types of databases using the SQL language.All you have to do if i suppose that you just want to use different columns at once is to specify it in you query just as "SELECT id,lastname,jop FROM your database WHERE your condition" you need here to pay attention on the condition so i suggest you to learn more about SQL Language to know exactly how to achieve your goal.