Forums :: Advanced Search

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Advanced Search

DwZone Forum Index -> Advanced Search

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 11 to 20 of 282 (Total: 122)

First | Prev | Next | Last

Subject

Author

Date

Re: Adv Search errors

Gianluigi

9:19 27 Apr 2013

Tutorial for Search form and display the result in 2 different pages

MarionSmidts

14:54 26 Mar 2013

Re: Tutorial for Search form and display the result in 2 different pages

Gianluigi

15:30 26 Mar 2013

Re: Tutorial for Search form and display the result in 2 different pages

MarionSmidts

23:39 26 Mar 2013

Re: Tutorial for Search form and display the result in 2 different pages

Gianluigi

11:36 27 Mar 2013

advancedsearch.js

luigi

2:56 18 Jan 2013

Re: advancedsearch.js

Gianluigi

3:22 18 Jan 2013

Age search help need!

cena

12:30 1 Nov 2012

This is my query : ---SELECT CURDATE() AS today, YEAR(CURDATE()) - YEAR(Dateofbirth) - IF(RIGHT(CURDATE(), 5) < RIGHT(Dateofbirth,5),1,0) AS age, users.Dateofbirth, users.userID, users.Firstname, users.Lastname, users.Dateofbirth, FROM users ORDER BY users.userID desc----

After when iam going to add a filter i want to select derived value of age. is it possible ? if not

than please tell me how to add derived value of age to filter by changing the below code ?

<?php
//**************************
// Advanced Search
// http://www.DwZone-it.com
// Version: 1.0.2
//**************************
$dwzSearch_1 = new dwzSearch();
$dwzSearch_1->Init();
$dwzSearch_1->SetFormName("");
$dwzSearch_1->SetSubmitName("");
$dwzSearch_1->AddFilter("users.Gender", "=", "", "lookingfor", "", "S", "0");
$dwzSearch_1->AddFilter("users.Dateofbirth", ">=", "", "ageFrom", "", "N", "0");
$dwzSearch_1->SetRecordset($Recordset1age, "Recordset1age");
$dwzSearch_1->SetSql($query_Recordset1age);
$dwzSearch_1->SetConnection($hostname_-----, $database_----, $username_----, $password_----);
$dwzSearch_1->Create();
if($dwzSearch_1->HasFilter()){
$dwzSearch_1->FilterRecordset();
}
//**************************
// Advanced Search
// End code
//**************************
?>

please help me urgent!
Thanks in advance!