Code: Select all
WHERE datecontactagain LIKE '$var1."-".$var3."-".$var2;'";Moderator: General Moderators
Code: Select all
WHERE datecontactagain LIKE '$var1."-".$var3."-".$var2;'";Code: Select all
WHERE datecontactagain LIKE '$var1."-".$var3."-".$var2;'";Code: Select all
$var1 = $_POST["datecontactagain_Year"];
$var2 = $_POST["datecontactagain_Day"];
$var3 = $_POST["datecontactagain_Month"];
$datecontactagain = $var1."-".$var3."-".$var2;
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$query = "SELECT
o.org_id,o.web_url,
p.person_id,p.org_id,p.salutation,p.firstname,p.surname,
p.organisation,p.role,p.address1,p.address2,p.city,
p.postcode,p.telephone,p.mobile,p.fax,p.dateoflastcontact,
p.datecontactagain,p.notes,p.email,
DATE_FORMAT(dateoflastcontact, '%M/%Y')
AS dateoflastcontact, DATE_FORMAT(datecontactagain, '%M/%Y')
AS datecontactagain
FROM people p LEFT JOIN organisations o
ON o.org_id = p.org_id
WHERE datecontactagain LIKE '$datecontactagain'";
$result = mysql_query($query);Code: Select all
DATE_FORMAT(dateoflastcontact, '%M/%Y') AS dateoflastcontact, DATE_FORMAT(datecontactagain, '%M/%Y') AS datecontactagainCode: Select all
DATE_FORMAT(dateoflastcontact, '%M/%Y') AS dateoflastcontact_formatted, DATE_FORMAT(datecontactagain, '%M/%Y') AS datecontactagain_formattedCode: Select all
WHERE datecontactagain LIKE '$datecontactagain'";