Roku Developer Program

[kooljay68]

<?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

[kooljay68]

OK .. this code does seem to work ... but now I get a repeat of the register process every time I click something ... what do I do to stop this ?

Thank you for the help.

-Jay