PHP Help

[Vivid Lust]

Hi, here is some of a script:

 

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$myusername = $_POST['myusername'];
$mypassword = $_POST['mypassword'];
$sql = "SELECT *, member FROM $tbl_name WHERE email='$myusername' and password='$encrypt'";
$result = mysql_query($sql);
$count = mysql_num_rows($result);
if($count==1){
session_register("myusername");
session_register("mypassword");
header("location:profile.php?member=".HERE);

 

Where i wrote HERE, how can i display the value of "member" from the query?

 

Thanks

[trq]

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$myusername = $_POST['myusername'];
$mypassword = $_POST['mypassword'];
$sql = "SELECT *, member FROM $tbl_name WHERE email='$myusername' and password='$encrypt'";
$result = mysql_query($sql);
$count = mysql_num_rows($result);
if($count==1){
  $row = mysql_fetch_assoc($result);
  $_SESSION['myusername'] = $myusername;
  header("location:profile.php?member=".$row['member']);
}

 

Note that session_register has long been depricated, and that there should also simply be no reason to store the users password in the session.