querry question

[eluser]daniel ispas[/eluser]
If Joe can be the name of the artist or the song name you should make a small change in the code provided by InsiteFX:

Code:

function get_artist($name)
{
    $data = array();

    $this->db->where('artist', $name);
    $this->db->or_where('song_name', $name);

    $query = $this->db->get('table_name');

    if ($query->num_rows() > 0){
      $data = $query->row_array();
    }

    $query->free_result();
    return $data;
}