nhojeinnor Posted February 1, 2011 Share Posted February 1, 2011 hi i have this function for select / function select($table, $rows = '*', $where = null, $group = null, $order = null, $limit = null) this is what i do to display the records. $db->select('loan'); $records = $db->getResult(); foreach($records as $row) { $user = $row['id']; //$name = $row['firstname']; //print_r($row); echo $user; ?> the codes is running.but when i want to use WHERE id = $_POST['id']; this is what im doing. $db->select('member')->where(array('id' => $_POST['client'])); an error as occured where in function where is not existing. please help how to use the proper way of using select * $table where id=$id; in array. thanks Link to comment https://forums.phpfreaks.com/topic/226311-select-query-using-array/ Share on other sites More sharing options...
nankoweap Posted February 1, 2011 Share Posted February 1, 2011 try this... $db->select('member', '*', 'id = ' . $_POST['id']); Link to comment https://forums.phpfreaks.com/topic/226311-select-query-using-array/#findComment-1168197 Share on other sites More sharing options...
nankoweap Posted February 1, 2011 Share Posted February 1, 2011 or rather... $db->select('member', '*', array('id' => $_POST['id'])); Link to comment https://forums.phpfreaks.com/topic/226311-select-query-using-array/#findComment-1168200 Share on other sites More sharing options...
nhojeinnor Posted February 1, 2011 Author Share Posted February 1, 2011 can i store it using array? like $data = array('id'=>$client); thanks Link to comment https://forums.phpfreaks.com/topic/226311-select-query-using-array/#findComment-1168219 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.