I have piece of PHP code written in Codeigniter framework that returns nothing (an empty set). Have a look at it and tell me what is wrong with it.
function sbsn($serial){
$this->db->select('asset_types.name as type_name,asset_brands.name as brand_name');
$this->db->from('asset_types,asset_brands,assets');
$this->db->where('assets.type_code','asset_types.code');
$this->db->where('assets.brand_code','asset_brands.code');
$this->db->where('serial_no',$serial);
$result = $this->db->get();
return $result;
}
我有一些用Codeigniter框架编写的PHP代码，它不返回任何内容（空集）。 看看 然后告诉我它有什么问题。
function sbsn（$ serial）{
$ this-＆gt; db-＆gt; select（'asset_types.name as type_name ，asset_brands.name为brand_name'）;
$ this-＆gt; db-＆gt; from（'asset_types，asset_brands，assets'）;
$ this-＆gt; db-＆gt; where（'assets.type_code'， 'asset_types.code'）;
$ this-＆gt; db-＆gt; where（'assets.brand_code'，'asset_brands.code'）;
$ this-＆gt; db-＆gt; where（'serial_no'， $串行）;
$ result = $ this-＆gt; db-＆gt; get（）;
返回$ result;
}
微信扫一扫
