hi i have encountered a error in my script and i am struggling to find the solution the following error is An Internal Error has Occured. Please report following error to the webmaster.
select count(*) from user where user_name LIKE '%matureco%' and status = '1'
and the section for the code is
// Searching criteria $column = "select * "; $search_user = $_GET['search_user']; $search = " from user where user_name LIKE '%$search_user%' and status = '1'"; $sql1 = " select count(*) ".$search; $search .= $search_ord; $search .= " limit $start, $pagesize "; $sql = $column.$search; $reccnt = getSingleResult($sql1); $finalsearch = mysqli_query($conn,$sql);
any help would be much appreciated ty