| 29 |
# user pressed submit |
# user pressed submit |
| 30 |
|
|
| 31 |
if ($city || $country) { |
if ($city || $country) { |
| 32 |
$sql = "SELECT id FROM people2 WHERE email = '$s_username'"; |
$sql = "SELECT id FROM people WHERE email = '$s_username'"; |
| 33 |
if (! ($result = pg_exec($db, $sql))) { |
if (! ($result = pg_exec($db, $sql))) { |
| 34 |
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
| 35 |
return FALSE; |
return FALSE; |
| 42 |
$who = $row["id"]; |
$who = $row["id"]; |
| 43 |
|
|
| 44 |
$now = strftime('%Y-%m-%d'); |
$now = strftime('%Y-%m-%d'); |
| 45 |
$sql = "UPDATE people2 SET last_update = '$now' WHERE id = '$who'"; |
$sql = "UPDATE people SET last_update = '$now' WHERE id = '$who'"; |
| 46 |
if (! ($result = pg_exec($db, $sql))) { |
if (! ($result = pg_exec($db, $sql))) { |
| 47 |
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
| 48 |
return FALSE; |
return FALSE; |