On Sep 9, 2:12*pm, Jerry Stuckle <jstuck...@attg lobal.netwrote:
JRough wrote:
I have used this function to create a string called $headers:
function GetHeaders($fil e_name){
* return "<th><a href='".$file_n ame."&order_by= l_e'>L_E</a></th>
* * * * * *<th><a href='".$file_n ame."&order_by= carnumber'>Carn umber</a></th>
* * * * * *<th><a href='".$file_n ame."&order_by= location'>Locat ion</a></th>
* * * * * *<th><a href='".$file_n ame."&order_by= sighting_date_a sc'>Sighting
Date</a></th>
How can I tell if it worked or not? I tried adding these 2 lines and
did not get a value for $s1? The page does work.
$s1 = isset($_GET['order_by']) ? $_GET['order_by'] : '';
var_dump $s1;
it is in the else at the end where if the user wants to see the
browser page or if he wants to see it in Excel.
tia,
Janis
---------idle_cars.php-----
include './includes/config.inc.php' ;
include $include_path.' dates.inc.php';
include $include_path." LMS_functions.i nc.php";
#// ############### ############### ############### ##
#// Is the user logged in?
Validate_login( "idle_cars.php? id=".$id);
$days = 3;
$TPL_carnumbers = "<table>";
if(empty($order _by)){
$order_by = 'sighting_date_ asc';
}
# GET CARS FOR GIVEN PARAMETER?
if(empty($id)){
$MSG_carlist = "IDLE CARS - NO MOVEMENT IN 3 DAYS";
$file_name = "idle_cars.php? ";
switch ($_SESSION["LMS_USER_D ESC"]){
case 'internal':
$headers = GetLeaseHeaders ($file_name);
$result = SELECT_idle_day s($days,CLM_ord er_by($order_by ));
$lease_row = true;
break;
case 'owner':
$headers = GetLeaseHeaders ($file_name);
$result = SELECT_idle_day s_owner($days,C LM_order_by($or der_by));
$lease_row = true;
break;
case 'customer':
$headers = GetHeaders($fil e_name);
$result = SELECT_idle_day s_customer($day s,CLM_order_by( $order_by));
$lease_row = false;
break;
default:
$headers = GetLeaseHeaders ($file_name);
$result = SELECT_idle_day s($days,CLM_ord er_by($order_by ));
$lease_row = true;
break;
}
}else{
$MSG_carlist = "IDLE CARS - NO MOVEMENT IN 3 DAYS
".GetLeaseCompN ame($id);
$file_name = "idle_cars.php? id=".$id."&";
switch ($_SESSION["LMS_USER_D ESC"]){
case 'internal':
$headers = GetHeaders($fil e_name);
$result = SELECT_idle_day s_lease($id,
$days,CLM_order _by($order_by)) ;
$lease_row = false;
break;
case 'owner':
$headers = GetHeaders($fil e_name);
$result = SELECT_idle_day s_lease_owner($ id,
$days,CLM_order _by($order_by)) ;
$lease_row = false;
break;
default:
$headers = GetHeaders($fil e_name);
$result = SELECT_idle_day s_lease($id,
$days,CLM_order _by($order_by)) ;
$lease_row = false;
break;
}
}
$TPL_carnumbers .= $headers;
if ($_POST['assign']!='Open in Excel'){
if(mysql_numrow s($result)==0){
$TPL_carnumbers .= GetNoCarsMsg($t h);
}else{
while ($row = mysql_fetch_ass oc($result)){
$TPL_carnumbers .=MakeSighting( $lease_row,$row );
}
}
$TPL_carnumbers .="</table>";
include "header.php ";
include $template_path. "template_carli st.html";
include "footer.php ";
}else{
var_dump($resul t);
$s1 = isset($_GET['order_by']) ? $_GET['order_by'] : '';
var_dump($s1);
#$data.=makexcl ();
}
include "footer.php ";