สอบถามปัญหาการ Query ของ MySQL ซึ่งแสดงผลลัพธ์เพียง 50 จาก 500

	public function select_publisher_name()
	{
		$this->load->model('research_model');

		if( ! $xml = simplexml_load_file($_SERVER['DOCUMENT_ROOT'].'/gophp/xml/1x.xml'))
	    {
	        // echo 'unable to load XML file';
	    }
	    else
	    {
			foreach ($xml->children() as $child)
			{
				foreach ($child->children() as $child2) {
					foreach ($child2->children() as $child3) {
			    		$getAuthor = $child3->getName();
			    		if($getAuthor=='journal' OR $getAuthor=='booktitle'){
			    			$name = substr($child3, 1, -1);
							$result = $this->research_model->select_name($name);
							print_r($result);
							echo "<br>";
			    		}
					}
				}
			}
		}
	}

	function select_name($name)
	{
		$select = parent::select();
		$select->from('publisher');
		$select->where('name LIKE ?', '%'.$name.'%');
		$result = parent::fetchAll($select);
		return $result;
	}