[RESOLVED] couldn't fetch mysqli_result

[jrough]

I get no data when I run an AJAX js script I get the mysqli connection but I don't get the todo list result rows.

Success... 127.0.0.1 via TCP/IP
array(0) {
}
This is the first time I used MySQLi.
I should have the todo, date and name printed out for the returned response.
thanks,

require_once 'lib/global.inc.php';
ini_set('error_reporting', E_ALL);
error_log("get_todosx error",3,"/var/tmp/Janis-Rough.local.err");

$mysqli = new mysqli($dbhost,$dbuser, $dbpass, $dbname,$dbport);
if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}
echo 'Success... ' . $mysqli->host_info . "\n";




$sql = 'SELECT todo,date,name FROM task WHERE todo IS NOT NULL || > "" ';
$result = $mysqli->query($sql);

if($result = $mysqli->query($sql)){

while($obj = $result->fetch_object())
	{
		printf( $obj->todo, $obj->date, $obj->name);
	}	
$result->close();
}//end if


$mysqli->close();
[\php]

[jrough]

I'm closing this thread and moving it to other UI applications JQuery. The reason is I just re-ran the page (script) and I got a result. I didn't really change anything. I just changed the css to a related style sheet. I now get rows of data. It just isn't printing to my Jquery script. thanks,