Do a POST to the action when the users clicks submit in the form or do this with ajax if you don't want the whole page to be refreshed
Also why are you using query ? its only for sql that can't be handled by cake and your's looks pretty basic. Generally you're doing a search box. <autopromotion> http://wiki.kabturek.info/paginating_search_results </autopromotion> not all aplies for you cause you want to do it on the same page but look at the code and you'll find some usefull snippets greets, On Aug 10, 4:57 am, mussond <[EMAIL PROTECTED]> wrote: > I'd like to filter my view based on the input from the user. The > thought is the user will enter a date range using input text boxes. > These values would be passed to the controller and an query($sql) > would return values I'll display in a table. > > I can get the query and the table to work no problem but I can't find > a way to get the date values from the view to the controller and thus > be used in the query. > > I've got two text inputs that contain the MIN and MAX date values from > the database. > > <label>start:</label><INPUT TYPE=text NAME="dateMIN" VALUE ="<?php > echo $min[0][0]['min'];?>"/> > > <label>end:</label><INPUT TYPE=text NAME="dateMAX" VALUE ="<?php echo > $max[0][0]['max'];?>"/> > > Also the user will filter the query by selecting a user id from a > select box. In my controller I set this value to the variable > $id_user, which is then used in the query(): > > $id_user = $this->data['ComUser']['id']; > > $this->set('data', $this->DataPoint->query("SELECT w.com_user_id, > count(p.id) as c FROM data_points p join des_walks w WHERE > p.des_walk_id = w.id AND w.com_user_id = '$id_user' AND p.date >= > '2006-12-09' AND p.date <= '2006-12-10' GROUP BY w.com_user_id")); > > So my question is how can I replace the '2006-12-09' and '2006-12-10' > with whatever is written in the text boxes? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
