Some help please :)

bdwarr6

Limp Gawd
Joined
Dec 11, 2006
Messages
169
PHP:
$query_rscases1 = "SELECT cases.gen_f_name, cases.gen_l_name FROM cases WHERE {$NXTFilter_rscases1} ORDER BY {$NXTSort_rscases1}";
$query_limit_rscases1 = sprintf("%s LIMIT %d, %d", $query_rscases1, $startRow_rscases1, $maxRows_rscases1);
$rscases1 = mysql_query($query_limit_rscases1, $data) or die(mysql_error());
$row_rscases1 = mysql_fetch_assoc($rscases1);

Im stumped here I need to limit this to a variable that is $_SESSION['kt_login_user'];

Basically I only want the page to display the records of $_SESSION['kt_login_user'];
 
PHP:
$query_rscases1 = "SELECT cases.gen_f_name, cases.gen_l_name FROM cases WHERE {$NXTFilter_rscases1} ORDER BY {$NXTSort_rscases1}";
$query_limit_rscases1 = sprintf("%s LIMIT %d, %d", $query_rscases1, $startRow_rscases1, $maxRows_rscases1);
$rscases1 = mysql_query($query_limit_rscases1, $data) or die(mysql_error());
$row_rscases1 = mysql_fetch_assoc($rscases1);

Im stumped here I need to limit this to a variable that is $_SESSION['kt_login_user'];

Basically I only want the page to display the records of $_SESSION['kt_login_user'];

What is stored in $_SESSION['kt_login_user'], a user's login name? What does the cases table have to do with this?
 
  1. Please use descriptive thread titles.
  2. what is in $NXTFilter_rscases1? you haven't given enough context
  3. What do your tables look like?
  4. I get the feeling you didn't write this originally. Is it an open-source app or something you inherited? If open source, WTF is it?

You'll probably need to add an extra condition to $NXTFilter_rscases1 to limit the query to a user. This may or may not require you to join to another table.
 
Back
Top