[eluser]InsiteFX[/eluser]
So if JOE is an artist then it would be something like this
not sure if this will give your the output you want but try it.
Code:
function get_artist($name)
{
$data = array();
$this->db->where('artist', $name);
$this->db->where('song_name', $name);
$query = $this->db->get('table_name');
if ($query->num_rows() > 0){
$data = $query->row_array();
}
$query->free_result();
return $data;
}
InsiteFX