generate the link

[nrsh_ram]

hi,

i have try like this

all.php

 <td><a href="view_profile.php?mentee=<?php echo $row['mentee']; ?>"><?php echo $row['mentee']; ?></a>&nbsp;</td>

view_profile.php

$query = "SELECT * FROM mentee_personal_details where mentee_id = 'mentee'";
   $result = $conn->query($query);

its no error but, output is wrong..what shall i do?

[Krik]

You haven't defined a "$row[]" array anywhere. At least not in the snippets you gave us.

[nrsh_ram]

all.php

<?php
require_once('include/session.php');
require_once('include/user_auth_fns.php');
require_once('include/db_fns.php');

$cur_login = $_SESSION["username"];
$conn= db_connect();

$aa=0;
 $query = "SELECT mm.mentee, mm.username_mentee, mp.major ".
 "FROM mentormentee mm LEFT JOIN mentee_personal_details mp ".
   "ON mp.mentee_id = mm.username_mentee ".
        "WHERE mm.username_mentor = '$cur_login' AND mp.mentee_id = mm.username_mentee";   


  $result = $conn->query($query); 

?>


<?php

		while ($row = mysqli_fetch_assoc($result)){ 
		$aa = $aa + 1;
		?>
    <td><?php echo $aa ?>&nbsp;</td>
    <td><a href="view_profile.php?mentee=<?php echo $row['mentee']; ?>"><?php echo $row['mentee']; ?></a>&nbsp;</td>
    <td><?php echo $row['username_mentee']; ?>&nbsp;</td>
    <td><?php echo $row['major']; ?>&nbsp;</td>
  </tr><?php }?>

view_profile.php

<?php
require_once('include/session.php');
require_once('include/user_auth_fns.php');
require_once('include/db_fns.php');

$cur_login = $_SESSION["username"];
$conn= db_connect();

$aa=0;
 $query = "SELECT mm.mentee, mm.username_mentee, mp.major ".
 "FROM mentormentee mm LEFT JOIN mentee_personal_details mp ".
   "ON mp.mentee_id = mm.username_mentee ". 
        "WHERE mm.username_mentor = '$cur_login' AND mp.mentee_id = mm.username_mentee";   

 $result = $conn->query($query);

  $row = mysqli_fetch_assoc($result);{
   $m_mentee = $row['mentee'];
  }

  $query1 = "SELECT * FROM mentee_personal_details where mentee_id = '$m_mentee'";
   $result1 = $conn->query($query1);

$row1 = mysqli_fetch_assoc($result1);{
            $mentee_id            = $row1["mentee_id"]; 
			 $s_fullname           =  $row1["fullname"];
			$s_postal_address1    = $row1["postal_address1"];
			$s_postal_address2	  = $row1["postal_address2"];
            $s_postal_address3	  = $row1["postal_address3"];
            $s_postal_zip 		  = $row1["postal_zip"];
            $s_post_telephone 	  = $row1["post_telephone"];
            $s_degree 			  = $row1["degree"];
			$s_major              = $row1["major"];
            $s_race 			  = $row1["race"];
            $s_marital_status 	  = $row1["marital_status"];
			$s_hobbies            = $row1["hobbies"];
            $s_permanent_address1 = $row1["permanent_address1"];
            $s_permanent_address2 = $row1["permanent_address2"];
            $s_permanent_address3 = $row1["permanent_address3"];
            $s_per_zip 			  = $row1["per_zip"];
            $s_per_telephone	  = $row1["per_telephone"];	

  } 
?>

 <td><?php echo  $mentee_id;  ?><font face="Verdana" size="2">&nbsp;</font></td>

its no errors, but return mentee_id ="0", wrong output

[djjjozsi]

mentee didn't visible in view_profile.php, i did't see $_GET["mentee"] value in you code...

print your queries, and test in phpmyadmin.

if you expect more then one row from an sql query, you have to use a while cycle to print it, or build another array.
lets see this lines.

  $row = mysqli_fetch_assoc($result);{
   $m_mentee = $row['mentee'];
  }

you didn't need to recreate variables from the $rows array, use

extract($row1); 

(http://hu2.php.net/manual/en/function.extract.php)

and use php BB code not the Code please...