[eluser]quasiperfect[/eluser]
please delete this is found the problem
i have another query on top
Code:
$this->db->query("CALL delete_messages();");
that is triggering the error messages
using simple_query it works
hi
i have a error in my logs
Code:
ERROR - 2010-09-16 11:23:05 --> Severity: Warning --> mysql(): supplied argument is not a valid MySQL result resource C:\wamp\www\final\system\database\drivers\mysql\mysql_result.php 37
i use ci2
i found the function and model that produces the error but is nothing wrong there
the query returns the results correctly and everything works but this keeps appearing in the logs so is confusing
i run the generated query in phpmyadmin and it works ok
i can't use simple query because i return results and use the results
my code is
Code:
$query = $this->db->query("my query here");
$myerror = $this->db->_error_message();
if ($myerror)
{
log_message('error','Hmm problem :'.$myerror);
}
else
{
if ($query->num_rows() > 0)
{
//do something
}
else
{
//do something else
}
}