Code: Select all
array (
'DATE_SUB(`loanerin`,INTERVAL `loanerout` DAY)' => NULL,
)Moderator: General Moderators
Code: Select all
array (
'DATE_SUB(`loanerin`,INTERVAL `loanerout` DAY)' => NULL,
)Code: Select all
SELECT * FROM loan_clients WHERE `loanerin` IS NULL AND `loaderout` <= DATE_SUB(NOW(), INTERVAL 1 WEEK) AND DAYOFWEEK(`loanerout`) = DAYOFWEEK(DATE_SUB(NOW(), INTERVAL 1 WEEK))Code: Select all
Warning: mysql_fetch_array(): supplied argument is not a valid MySQLCode: Select all
1Code: Select all
WHERE loanerin IS NULLCode: Select all
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WEEK) AND DAYOFWEEK(`loanerout`) = DAYOFWEEK(DATE_SUB(NOW(),Code: Select all
array (
0 => '1',
'clientsid' => '1',
1 => 'Igor',
'fname' => 'Igor',
2 => 'Polanski',
'lname' => 'Polanski',
3 => 'Key to health',
'ciename' => 'Key to health',
4 => '416-736-1223',
'ciephone ' => '416-736-1223',
5 => '45 oakmaunt rd. #501',
'address ' => '45 oakmaunt rd. #501',
6 => 'toronto',
'city' => 'toronto',
7 => 'M6P 2M4',
'postal' => 'M6P 2M4',
8 => '',
'hoursmade' => '',
9 => '2004-07-27 16:30:00',
'loanerout' => '2004-07-27 16:30:00',
10 => '2004-08-11 10:30:00',
'loanerin' => '2004-08-11 10:30:00',
11 => '3',
'loanerid' => '3',
12 => '1',
'loanerflag' => '1',
)Code: Select all
7 DAYCode: Select all
$date_diff=$myarray[10] - $myarray[9];Code: Select all
SELECT *, TO_DAYS(`loanerout`) - TO_DAYS(`loanerin`) `days out` FROM loan_clients ..........Code: Select all
<?php
if(!isset($_SESSION['name'])){
echo("Need to log in first <a href="index.php">click here</a> to log in");
}else{
$sql = "SELECT * FROM loan_clients WHERE clientsid='$clientsid'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$sql_math = "SELECT *, TO_DAYS(`loanerin`) - TO_DAYS(`loanerout`) `days out` FROM loan_clients";
$calcul = mysql_query($sql_math) or die(mysql_error());
$date_diff = mysql_fetch_row($calcul);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?php
echo("
<tr>
<td><strong>First Name</strong></td>
<td>$row[1]</td>
</tr>
<tr>
<td><strong>Last Name</strong></td>
<td>$row[2]</td>
</tr>
<tr>
<td><strong>Compagny Name</strong></td>
<td>$row[3]</td>
</tr>
<tr>
<td><strong>Compagny Phone</strong></td>
<td>$row[4]</td>
</tr>
<tr>
<td><strong>Address</strong></td>
<td>$row[5]</td>
</tr>
<tr>
<td><strong>City</strong></td>
<td>$row[6]</td>
</tr>
<tr>
<td><strong>Postal Code</strong></td>
<td>$row[7]</td>
</tr>
<tr>
<td><strong>Hours Made</strong></td>
<td>$row[8]</td>
</tr>
<tr>
<td><strong>Loaner Sent</strong></td>
<td>$row[9]</td>
</tr>
<tr>
<td><strong>Loaner Received</strong></td>
<td>$row[10]</td>
</tr>");
if($row[12] == 1){
echo("
<tr>
<td><strong>Time Kept</strong></td>
<td>$date_diff[13] days</td>
</tr>
");
}
}
?>
</tr>
</table>
<br /><a href="../summary.php">Go back</a>