OK so here my main issue. I have a register piece that allows a user to signup online. Now i have a login script. All works fine.But my username was fueling my website meaning php links. But it only works if i use last name for the username. I have one database with all my information in and i took the username and compared it to the last name in the database.

but i want to be albe to let the user register their own name and then when they log in i will show them only there information>>
heres what im using now as my select staement.

$searchtype =$HTTP_POST_VARS['name'];
$conn = mysql_connect("localhost","ein","9t");
$sql= "select * from mem where Surname = '".$searchtype."' ";
$result=mysql_query($sql,$conn) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)){
echo '<font size=\"2\">Welcome,<font color="Black"><b><font size=\"2\">&nbsp;'.($firstname).'&nbsp;'.($lastnam e).'</font></b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;</br>';
} ?>