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 Quote Link to comment 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']); Quote Link to comment 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'])); Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.