| 24 |
return FALSE; |
return FALSE; |
| 25 |
} |
} |
| 26 |
|
|
|
$sql = "SELECT id FROM people WHERE email = '$s_username'"; |
|
|
if (! ($result = pg_exec($db, $sql))) { |
|
|
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
|
|
return FALSE; |
|
|
} |
|
|
if (pg_NumRows($result) != 1) { |
|
|
echo "That e-mail address is wicked."; |
|
|
return FALSE; |
|
|
} |
|
|
$row = pg_Fetch_Array($result, 0); |
|
|
$who = $row["id"]; |
|
| 27 |
|
|
| 28 |
|
# user pressed submit |
| 29 |
|
|
| 30 |
# begin, finish |
if ($city || $country) { |
| 31 |
|
$sql = "SELECT id FROM people WHERE email = '$s_username'"; |
| 32 |
|
if (! ($result = pg_exec($db, $sql))) { |
| 33 |
|
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
| 34 |
|
return FALSE; |
| 35 |
|
} |
| 36 |
|
if (pg_NumRows($result) != 1) { |
| 37 |
|
echo "That e-mail address is wicked."; |
| 38 |
|
return FALSE; |
| 39 |
|
} |
| 40 |
|
$row = pg_Fetch_Array($result, 0); |
| 41 |
|
$who = $row["id"]; |
| 42 |
|
|
| 43 |
|
echo "$city, $country"; |
| 44 |
|
echo "<P>"; |
| 45 |
|
echo "$begin_year, $begin_month, $begin_day"; |
| 46 |
|
echo "<P>"; |
| 47 |
|
echo "$end_year, $end_month, $end_day"; |
| 48 |
|
echo "<P>"; |
| 49 |
|
|
| 50 |
|
return TRUE; |
| 51 |
|
} |
| 52 |
|
|
|
# city, country |
|
| 53 |
|
|
| 54 |
|
# user wants to fill out the form |
| 55 |
|
|
| 56 |
# modify an entry (if $id exists), or add a new one) |
# modify an entry (if $id exists), or add a new one) |
| 57 |
if ($id) { |
if ($id) { |
| 149 |
|
|
| 150 |
<TR><TD><B>City</B></TD><TD><INPUT name = "city" type = "text" value="<? echo $city ?>"></TD></TR> |
<TR><TD><B>City</B></TD><TD><INPUT name = "city" type = "text" value="<? echo $city ?>"></TD></TR> |
| 151 |
<TR><TD><B>Country</B></TD><TD><INPUT name = "country" type = "text" value="<? echo $country ?>"></TD></TR> |
<TR><TD><B>Country</B></TD><TD><INPUT name = "country" type = "text" value="<? echo $country ?>"></TD></TR> |
| 152 |
|
<TR><TD> </TD><TD><INPUT type="submit" value="Submit"></TD></TR> |
| 153 |
</FORM> |
</FORM> |
| 154 |
</TD> |
</TD> |
| 155 |
</TR> |
</TR> |