[drupal-devel] Passing sql variables to a paged query

[Richard Grieve]

Hi all,

I am trying to creat a useable profile search for an alumni site. The sql
searches on up to 9 different profile values, which are selected in a form.
I have used a paged query and the first page returns fine. However on page 2
the whole user list (2500 users) is returned because no variables are passed
to the query. Is there any way I can pass the variables (as hidden form
values?) to the pager query so that the pages return correctly.

The sql is below:

$sql = "SELECT u.uid, ";
$sql .= "v1.value as given_name, ";
$sql .= "v2.value as last_name, ";
$sql .= "v3.value as degree, ";
$sql .= "v4.value as college, ";
$sql .= "v5.value as matriculation_year, ";
$sql .= "v6.value as company, ";
$sql .= "v7.value as town, ";
$sql .= "v8.value as nationality, ";
$sql .= "v9.value as sector, ";
$sql .= "v10.value as position ";
$sql .= "FROM users u ";
$sql .= "LEFT OUTER JOIN profile_values v1 ON u.uid = v1.uid AND v1.fid =
'2' ";
$sql .= "LEFT OUTER JOIN profile_values v2 ON u.uid = v2.uid AND v2.fid =
'4' ";
$sql .= "LEFT OUTER JOIN profile_values v3 ON u.uid = v3.uid AND v3.fid =
'45' ";
$sql .= "LEFT OUTER JOIN profile_values v4 ON u.uid = v4.uid AND v4.fid =
'44' ";
$sql .= "LEFT OUTER JOIN profile_values v5 ON u.uid = v5.uid AND v5.fid =
'42' ";
$sql .= "LEFT OUTER JOIN profile_values v6 ON u.uid = v6.uid AND v6.fid =
'73' ";
$sql .= "LEFT OUTER JOIN profile_values v7 ON u.uid = v7.uid AND v7.fid =
'13' ";
$sql .= "LEFT OUTER JOIN profile_values v8 ON u.uid = v8.uid AND v8.fid =
'6' ";
$sql .= "LEFT OUTER JOIN profile_values v9 ON u.uid = v9.uid AND v9.fid =
'72' ";
$sql .= "LEFT OUTER JOIN profile_values v10 ON u.uid = v10.uid AND v10.fid=
'24' ";
$sql .= "WHERE v10.value LIKE '%%' ";
$sql .= "AND v1.value LIKE '%" . $_POST['profile_given_name'] . "%' ";
$sql .= "AND v2.value LIKE '%" . $_POST['profile_last_name'] . "%' ";
$sql .= "AND v3.value LIKE '%" . $_POST['profile_degree'] . "%' ";
$sql .= "AND v4.value LIKE '%" . $_POST['profile_college'] . "' ";
$sql .= "AND v5.value LIKE '%" . $_POST['profile_matriculation_year'] . "%'
";
$sql .= "AND v6.value LIKE '%" . $_POST['profile_company'] . "%' ";
$sql .= "AND v7.value LIKE '%" . $_POST['profile_town'] . "%' ";
$sql .= "AND v8.value LIKE '%" . $_POST['profile_nationality'] . "%' ";
$sql .= "AND v9.value LIKE '%" . $_POST['profile_sector'] . "%' ";
$sql .= "ORDER BY last_name";

Any ideas would be very much appreciated!

Richard Grieve
etribes Limited
www.etribes.com

Online community & Internet consultancy, design, development and hosting
solutions

--------------------------------------------

Tel: 0845 458 1880
Mobile: 07876 500606
www.midentity.com/richardgrieve

Registered Office: Skyview Centre, Churchfield Road, Sudbury, Suffolk, CO10
2YA