Re: Capturing a sql query

Trying to set this up and have a question: Example below , the example for state. The field name is s_LocationState The variable is set to state. $State = ""; // check any item is selected if (count($s_LocationState) > 0 AND is_array($s_LocationState)) { $State = "'".implode("','", $s_LocationState)."'"; So in this example, which should be the keywords, and I'm thinking it probably doesn't matter. The s_fields though are more parameters then variables. ?? > $searchQuery = array(); > $searchQuery["Keywords"]= $_POST["keyword"]; > $searchQuery["JobCategory"]= $_POST["category"]; > $searchQuery["Pay"]=$_POST["pay"]; Thank you , Stuart --- M Saleh EG <m.saleh.eg@gmail.com> wrote: > I'd recommand u to use a serialized variable saved > in ur database. > As in the an array of keywords saved in an > serialized variable once > the form is submited to save the query. > e.g. > $searchQuery = array(); > $searchQuery["Keywords"]= $_POST["keyword"]; > $searchQuery["JobCategory"]= $_POST["category"]; > $searchQuery["Pay"]=$_POST["pay"]; > ... > ... > ... > $s_sq=serialize($searchQuery); > > then save $s_sq into ur DB. >