EchoSeven

thanks

i found the error. it wasn't the script. my MySQL program corrupts the database when it starts up. i had to redo the database.. how can i stop this? or would this be something for another forum?

Done. the output is the error, then the query formatted as it should. this is not the problem.

Hello. i am writing an API for lua... that sends POST requests to a php script. this php script is malfunctioning. below is the code and error. Code: <?php $host = $_POST['host']; $port = $_POST['port']; $user = $_POST['user']; $password = $_POST['password']; $db = $_POST['db']; $query = $_POST['query']; $query = urldecode($query); $connection = mysql_connect($host,$user,$password) or die("err1"); mysql_select_db($db) or die("err2"); $resource = mysql_query($query); $rows = array(); while($r = mysql_fetch_object($resource)){ $rows[] = $r; } echo json_encode($rows); //echo $rows; mysql_close(); ?> Error: html passed to JSON:decode(): <br /><b>Warning</b>: mysql_fetch_object(): supplied argument is not valid MySQL result resource in [server url] on line 17 Note: it does actually connect to the Database as per previous experiments with the code. JSON:decode() is working and therefore not the problem, since it was the PHP that gave this error to the JSON handler API. The server is working correctly as i use it all the time to make MySQL requests. though, never with this php code. i use a framework to do it for me. but it seems to be working correctly which verifies this php script ás what is malfunctioning.