Ok, that code is working perfectly now. It connects, queries and writes to the db exactly as it should (thanks everyone!!!).
Now, if anyone is interested, I am having a new problem.
Here is the problematic code:
require '../htdocs/config.php';
require '../util.php';
function update_req($reqid, $status)
{
$query = "
UPDATE requests
SET status='$status'
WHERE
reqid='$reqid'
AND curr_type='RUC'
";
do_query($query);
}
$query = "
SELECT
requests.reqid AS reqid,
uid,
amount,
addy
FROM requests
JOIN rucoin_requests
ON requests.reqid=rucoin_requests.reqid
WHERE
req_type='WITHDR'
AND amount > '0'
AND status='VERIFY'
AND curr_type='RUC'
";
$result = do_query($query);
$rucoin = connect_rucoin();
while ($row = mysql_fetch_assoc($result)) {
$reqid = $row['reqid'];
$uid = $row['uid'];
$amount = $row['amount'];
$addy = $row['addy'];
if (gmp_cmp($rucoin->getbalance(""), $amount) >= '0')
{
update_req($reqid, "PROCES");
$rucoin->sendfrom("", $addy, $amount);
update_req($reqid, "FINAL");
}
}
?>
This code should check the "requests" table for "req_type='WITHDR'" with amounts greater than '0' with "status='verify'" and "curr_type='RUC'" and when it finds a transaction it copies the "reqid" and "addy" into a table called "rucoin_requests". This part of the code works.
From there the script should connect to rucoin, check to make sure the default account has enough funds to send the requested withdrawal amount. Upon verification of funds it should connect to the table "requests" and update the status to "PROCES". After that it should connect to rucoin and "sendfrom" the default ("") account the requested "$amount" to the "$addy" listed in the "rucoin_requests" table.
Right now, the code seems to be stuck after it updates the status to "verify" and copies the "reqid" and "addy" into the "rucoin_requests" table...
