updating results in empty records!!!!1

[ausgezeichnete]

this is my code
and i don't see the problem
every time am trying to edit something it gives empty record

<?php
$conn=mysqli_connect("localhost","root","","cars");
$result=mysqli_query($conn,"select * from login where username='".$username."'");
$record=mysqli_fetch_array($result,MYSQLI_ASSOC);
$fields=mysqli_fetch_fields($result);

$id=addslashes($_REQUEST['id']);
$username=addslashes($_REQUEST['username']);
$password=addslashes($_REQUEST['password']);
$gender=addslashes($_REQUEST['gender']);
$email=addslashes($_REQUEST['email']);
$sql=mysqli_query($conn,"UPDATE login SET email = '".$email."' , id ='".$id."' Where username = '".$username."' ");
if(!$sql){echo"Wrongggggg";}

[Piranha]

I have no idea why you get the error you have. But I have spotted a few other problems with your code.

1. Why do you run a select query first? You don't use it in any way to see if there is a user with that name.

2. You use addslashed. That is not a good idea, it is much better to use the database specific functions, fo mysqli I think it is mysqli_escape_string. With addslashes it is possible that it won't be 100% protected, and you will get into trouble if something other than PHP should access the database.

[ausgezeichnete]

it worked thnxx
i wrote
echo $email after the code and it saw it
but plz could u help me to output this
header("location:showmydetails?username=<?php echo $username;?>");
the syntax driving me crazy

Edit/Delete Message

[roscor]

Not sure but,

header(location:showmydetails?username='$username'>);