0

in this query format i want to display the Memr_Name. how can i get the values from this query

$qryStr = mysqli_prepare($connection, "SELECT Memr_Name, MEMBER.Memr_Id from MEMBER, VOLUNTEER ".
                    " WHERE MEMBER.Memr_Id = VOLUNTEER.Memr_Id AND VOLUNTEER.Batch= ? ".
                    " AND VOLUNTEER.Task_Id = 'COR_GNRL' AND ".
                    " VOLUNTEER.Chapter_Id = ? ORDER BY Memr_Name ASC");
                    mysqli_stmt_bind_param($qryStr, "ss", $year, $chapterId );
                    mysqli_stmt_execute($qryStr);
                    mysqli_stmt_store_result($qryStr);
                    $loginNumRow = mysqli_stmt_num_rows($qryStr);
                    mysqli_stmt_bind_result($qryStr, $year, $chapterId);
                    $data = mysqli_stmt_affected_rows($qryStr);

                  if($data>0){
                  while ($row = mysqli_stmt_fetch($qryStr)) {
                        echo "<a href=\"TM_MemberList.php?year=$year&amp;coord=$row[1]\">$row[0]</a> <br>";
                        echo $row['Memr_Id'];

                     }
                  }

if i use this while loop am getting empty values.

2
Contributors
1
Reply
27
Views
3 Years
Discussion Span
Last Post by gabrielcastillo
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.