Hi, Firstly the code is great, secondly the code is great and finally i have some question :) I'm trying to chande the code a bit. I had to add extra field in job advertisement. I've added input field into form, additional field in database and also changed the class.Job file to save this data into database. Everything works fine, all data is saving correctly. But now i don't know why the search engine doesn't look through this extra field too. Any idea?
Sorry for my english. i'm a foreign speaker and i'm still studying :)
Hi, I wanted to add extra field in job advertisement. In my case it was “special ability” (like driving licence or karate black belt ;p). Firstly i did like in http://www.jobberbase.com/community/discussion/76/adding-salary-and-expires-field. After that everything was fine. I could add extra information in form and it was saved in the database. But… but when i was searching for some job advertisement i’ve noticed that the search engine doesn’t look trough this field. The problem why is in class.Job.php file. Near 550 line you have something like:
$conditions = 'title LIKE "%' . $keywords . '%" OR company LIKE "%' . $keywords . '%"' . ' OR description LIKE "%' . $keywords . '%" OR outside_location LIKE "%' . $keywords . '%"' . $extra_conditions;
I modified this a bit:
$conditions = 'title LIKE "%' . $keywords . '%" OR company LIKE "%' . $keywords . '%"' . 'OR sp_field LIKE "%' . $keywords . '%"' . ' OR description LIKE "%' . $keywords . '%" OR outside_location LIKE "%' . $keywords . '%"' . $extra_conditions;