[eluser]quibstar[/eluser]
I'm trying to retrieve one object from a table, Just the username from a user table using the blog id from a blog table
This is in my model:
Code:
function getUsername($blog_id)
{
$q=mysql_query("SELECT username
FROM blog
JOIN users USING ( user_id )WHERE blog_id=$blog_id");
$data = $this->db->query($q);
return $data->result();
}
This is in my controller:
Code:
$this->load->model('blog_model');
$username = $this->blog_model->getUsername($this->input->post('id'));
I keep getting errors like:
A PHP Error was encountered
Severity: Warning
Message: preg_match() expects parameter 2 to be string, resource given
Filename: mysql/mysql_driver.php
Line Number: 160
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #41' at line 1
Resource id #41
Any help would be appreciated. Thanks