Dear friends!
I am new in PHP and MYSQL.I am developing Library managment system.I am facing
problem in coding.
I want to calculate and update Fine of Library members on daily basis.
My Database contains two columns .1. Issue Date and Due Date.
I want to fine member at $2 per day after due date.
I don't understand how to write code for that.Kindly if someone help me and
write exact code.
I have two options
1.Wether librarian clcik on button to activate fine status of all members
2.Librarian open admin view and fine status are updated automatically.
Kindly suggest me and help me.blow is some code
Thanks !
<?php
$today=date('d'); //today
$date=date('y-m-d'); //date
[EMAIL PROTECTED]("select * from issue_items ") or die(mysql_error());
while($row=mysql_fetch_array($results))
{
$date2=$row['DUE_DATE']; //due date of item
$due_day=substr("$date2",-2); //day in due date
$diff=0;
$diff=$today-$due_day;
if($diff<0) //if difference is (-ve) shows that month has changed
{
$diff=31+($diff);
}
[EMAIL PROTECTED]("update issue_items SET FINE=2*$diff ") or
die(mysql_error());
}
?>
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
[Non-text portions of this message have been removed]
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
