kill_bill wrote:
1. list of recent file for expired date < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename";
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $data['title'];
$expiry_date = $data['expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_list[] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_list[] = $title;
elseif($days_left > 14)
$super_alert_list[]= $title;
}
// now put array lists to select boxes
// ... i hope you know your way home from here
lled Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename";
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $data['title'];
$expiry_date = $data['expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_list[] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_list[] = $title;
elseif($days_left > 14)
$super_alert_list[]= $title;
}
// now put array lists to select boxes
// ... i hope you know your way home from here
y_date = $data['expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_list[] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_list[] = $title;
elseif($days_left > 14)
$super_alert_list[]= $title;
}
// now put array lists to select boxes
// ... i hope you know your way home from here
< 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename";
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $data['title'];
$expiry_date = $data['expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_list[] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_list[] = $title;
elseif($days_left > 14)
$super_alert_list[]= $title;
}
// now put array lists to select boxes
// ... i hope you know your way home from here
; 7 && $days_left <= 14)
$alert_list[] = $titl expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_listї] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_listї] = $title;
elseif($days_left &ed date < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_d"kill_bill"]
1. list of recent file for expired date < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename";
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $data['title'];
$expiry_date = $data['expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_list[] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_list[] = $title;
elseif($days_left > 14)
$super_alert_list[]= $title;
}
// now put array lists to select boxes
// ... i hope you know your way home from here
te < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_listї] = $title;
elseif($days_left > 7 && $days_left <= 1of recent file for expired date < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_listї] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_listї] = $title;
elseif($days_left > 14)
$super_alert_listї]= $title;
}
// now put array lists to select boxes
// ... i hope you know your way home from here
"kill_bill"]
1. list of recent file for expired date < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename";
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $data['title'];
$expiry_date = $data['expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_list[] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_list[] = $title;
elseif($days_left > 14)
$super_alert_list[]= $title;
}
// now put array lists to select boxes
// ... i hope you know your way home from here
[/php:1:64; 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'expiry_date'];
$days_left = getDateDiff(date('recent file for expired date < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename";
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'tibe put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_listї] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_listї] = $title;
elseif($days_left > 14)
$super_alert_listї]= $title;
}
// now put array lists to select boxes
/te > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'exlt; 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=my"kill_bill"]
1. list of recent file for expired date < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_listї] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_listї] = $title;
elseif($days_left > 14)
$super_alert_listї]= $titlut in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_listї] = $title;
elseif($days_left > 7 &&"kill_bill"]
1. list of recent file for expired date < 7 days will be put in a list called Recent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "e;SELECT * FROM tablename"e;;
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $dataї'title'];
$expiry_date = $dataї'expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_listї] ecent List
2. List of expired date > 7 and < 14 days will be put in a list called Alert List
3. List of expired date > 14 days will be put in a list called Super Alert List
[/quote]
I think you can accomplish this many ways. Here is an example:
Code: Select all
// prepare 3 arrays for different lists
$recent_list = $alert_list =$super_alert_list = array();
// get all items
$query = "SELECT * FROM tablename";
$result = mysql_query($query);
while($data=mysql_fetch_array($result)){
$title = $data['title'];
$expiry_date = $data['expiry_date'];
$days_left = getDateDiff(date('Y-m-d',$expiry_date); // user function or anything better
if($days_left <= 7)
$recent_list[] = $title;
elseif($days_left > 7 && $days_left <= 14)
$alert_list[] = $title;
elseif($days_left > 14)
$super_alert_list[]= $title;
}
// now put array lists to select boxes
// ... i hope you know your way home from here