[eluser]Unknown[/eluser]
EDIT: Resolved:
I had been using the wrong syntax from within Code Igniter Example for future and references:
$q = $this->load->database('database', TRUE);
$dev=$q->query("SQL QUERY IN HERE");
return $dev->result();
UNEDIT
[quote author="Aken" date="1347056624"]Post the query, and use $this->db->last_query() to see what the active record query being generated is. Compare those with your original and find the problem.[/quote]
Code:
$dev=$q->query("SQL QUERY IN HERE");
echo var_dump($dev);
echo"<hr />";
echo $q->last_query();
var_dump() returns:object(CI_DB_mysqli_result)#27 (7) { ["conn_id"]=> object(mysqli)#26 (17) { ["affected_rows"]=> int(51) ["client_info"]=> string(50) "mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $" ["client_version"]=> int(50008) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["field_count"]=> int(5) ["host_info"]=> string(26) "192.168.100.246 via TCP/IP" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(16) "5.1.57-community" ["server_version"]=> int(50157) ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(124707002) ["warning_count"]=> int(0) } ["result_id"]=> object(mysqli_result)#25 (5) { ["current_field"]=> int(0) ["field_count"]=> int(5) ["lengths"]=> NULL ["num_rows"]=> int(51) ["type"]=> int(0) } ["result_array"]=> array(0) { } ["result_object"]=> array(0) { } ["current_row"]=> int(0) ["num_rows"]=> int(51) ["row_data"]=> NULL }
last query returns: the full query even with the table