[mysql/php]need Som Basic Help

<?php
session_start();
include "database.php";
include "edit.inc.php";
if (!$_SESSION["valid_user"])
{
// User not logged in, redirect to login page
Header("Location: main.php");
}
if(isset($_POST['submit'])){

$email = $_POST['email'];
$msn = $_POST['msn'];
$info = $_POST['info'];

$updateemail = "UPDATE users SET email = '$email', msn = '$msn', info = '$info'
WHERE username = '$username'";

mysql_query($updateemail) or die("culd not edit your info");

echo "info updated";
}
// Display logout link
echo "<p><a href=\"member.php\">Click here to go back to info page!</a></p>";

echo "$email";
echo "$msn";
echo "$info";

$username = $_SESSION["username"];

$query = mysql_query("SELECT * FROM users WHERE username='$username'");

$all = mysql_fetch_array($query);

$email = $all['email'];
$msn = $all['msn'];
$info = $all['info'];





echo "
<table width=\"100%\" border=0 cellpadding=1 cellspacing=0>
<form name=login action='$PHP_SELF' method=post>
<tr>

<td width=80>Email: </td>
<td width='160'><input tabindex=1 type=text name=username value='$email' style='width:150;'></td>
</tr>
<tr>
<td>MSN: </td>
<td><input type=text name=password value='$msn' style='width:150'></td>
</tr>
<tr>
<td>Info: </td>
<td><textarea rows=\"10\" cols=\"45\" name=\"'info'\" id=\"'info'\">$info</textarea></td>
</tr>
";
echo "
</tr>
<tr>
<td>
<td colspan=\"3\">
<table border=0 cellspacing=0 cellpadding=0 width=100%>
<tr>
<td width=50%>
<input type=\"submit\" name=\"submit\" id=\"submit\" value=\"submit\" />
</form>
</table>
";

try moving $username above before your update query like this

this just delete the whole row in my user name so all go blank

try this



$username = $_SESSION["username"]; before the if statement

what do you mean delete? I only see an update statement and a select statement for displaying. If you get empty fields maybe the mysql database table is empty.

maybe try move the echo after the query is done