<?php
$con = mysql_connect("localhost","[username]","[password]");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("[DB]", $con);
$di = $_REQUEST[deviceID];
$result = mysql_query("SELECT * FROM user_info WHERE deviceId='$di' and misc1='1'");
while($row = mysql_fetch_array($result))
{
$status = $row['status'];
$token = $row['regToken'];
$id = $row['customerId'];
$time = $row['creationTime'];
}
mysql_close($con);
echo '<?xml version="1.0" encoding="utf-8" ?>';
echo '<result>';
echo '<status>',$status,'</status>';
echo '<regToken>',$token,'</regToken>';
echo '<customerId>',$id,'</customerId>';
echo '<creationTime>',$time,'</creationTime>';
echo '</result>';
?>
I am using the following code as my getRegResults page but I seem to be stuck in a loop where all I get is an error saying cannot connect to video service - please try again in a few min. I have finished everything else required to link the Roku box and even if I change the code to a simple xmll blank response I still get this error ... Please Help
Thank you
-Jay