Hopefully this is considered on-topic, please trim cc.
<?
// $Id: job.php,v 1.2 2000/04/17 08:59:57 bright Exp $
require ("$DOCUMENT_ROOT/includes/postgresql.php");
$dbh = database_connect();
$result = database_exec($dbh, "
SELECT
coder_id, name, phone_num, resume
FROM
coders
WHERE
attr_skill = 'guru'
AND (
(city = 'Santa Clara' AND state = 'CA')
OR relocate = 'willing'
)
;");
$count = database_getrows($result);
for ($i = 0; $i < $count; $i++) {
$row = database_fetch_array($result, $i);
if (eregi("(php|postgresql|cvs|freebsd|c programming)", $row["resume"])) {
$conversation = call($row["phone_num"]);
if (eregi("ninja skills", $conversation) &&
offer_accepted($row["name"], $row["phone"])) {
database_exec($dbh, "
INSERT INTO
employees
values ('" . addslashes($row["coder_id"]) . "', '" . addslashes($row["name"] .
"', 'engineer')
;");
database_exec($dbh, "
INSERT INTO
benifits
values ('" . addslashes($row["coder_id"] . "');
");
database_exec($dbh, "
UPDATE
benifits
SET
benifits = 'high',
salary = 'competative',
learning = 'high gear',
enviornment = 'layed back'
WHERE
coder_id = '" addslashes($row["coder_id"]) "'
;");
break;
}
}
}
header("Location: http://www.wintelcom.net/\n\n");
exit;
?>
Work with the best or die like the rest.
hope to hear from you,
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."