php - sql return one row While i have over than 50 rows -



php - sql return one row While i have over than 50 rows -

hi guys coded phpbb3 list friends in custom page code show 1 row , show 1 friend me while have on 50 friends ?! not expert in php started month. pleas if possible help resolve problem.thank in advance.

<? define('in_phpbb', true); $phpbb_root_path = (defined('phpbb_root_path')) ? phpbb_root_path : './forum/'; $phpex = substr(strrchr(__file__, '.'), 1); include($phpbb_root_path . 'common.' . $phpex); // start session management $user->session_begin(); $auth->acl($user->data); $user->setup(); include_once("./friends/connect.php"); $connect = new connect_to_db(); $user_id = $user->data['user_id']; // id useri ke login karde site $query = "select friend_id friends user_id = '".$user_id."' , friend =1"; $result = mysql_query($query,$connect->connect()); $connect->disconnect(); $row = mysql_fetch_array($result); $friends_id = $row['friend_id']; function get_f_name($friends_id) { global $db; $sql = 'select user_id,username,username_clean,user_avatar,group_id ' . users_table . ' user_id = ' . $db->sql_escape($friends_id); $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); if($row) { $friend = array( 'f_username' => $row['username'], 'f_username_clean' => $row['username_clean'], 'f_avatar' => $row['user_avatar'], 'f_group_id' => $row['group_id'], 'f_id' => $row['user_id'], ); homecoming $friend; } else { homecoming 'not valid user_id!'; } } $get_f_name_array = get_f_name($friends_id); //function called $template->assign_vars(array( 'f_username' => $get_f_name_array['f_username'], 'f_avatar' => $phpbb_root_path . "download/file.php?avatar=" . $get_f_name_array['f_avatar'], 'f_username_clean' => $get_f_name_array['f_username_clean'], 'f_group' => $get_f_name_array['f_group_id'], 'f_profile' => $phpbb_root_path . "memberlist.php?mode=viewprofile&u=". $get_f_name_array['f_id'], )); $template->set_filenames(array( 'body' => 'friends.html', )); make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpex")); page_footer(); ?>

while($row = mysql_fetch_array($result)){ $friends_id = $row['friend_id']; $get_f_name_array = get_f_name($friends_id); //function called $template->assign_vars(array( 'f_username' => $get_f_name_array['f_username'], 'f_avatar' => $phpbb_root_path . "download/file.php?avatar=" . $get_f_name_array['f_avatar'], 'f_username_clean' => $get_f_name_array['f_username_clean'], 'f_group' => $get_f_name_array['f_group_id'], 'f_profile' => $phpbb_root_path . "memberlist.php?mode=viewprofile&u=". $get_f_name_array['f_id'], )); $template->set_filenames(array( 'body' => 'friends.html', )); } make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpex")); page_footer();

php sql

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more