can u check out this ones

[zee000]

hi
can u check this coad and suggest me ones


<?php
include"conifig.php";
$password=$_POST['password'];
echo $_GET[username];

$pass=md5($_POST[password]);

mysql_query("UPDATE `table` SET `Password` = $pass WHERE `meconzee1_user` Loginname='".$_GET[username]."''");

echo "your password successfully changed";

mysql_close($con);

?>

this query is not working can u suggest any better code for me

[Schmoopy]

Missing quotes in the $_POST variables, here you go:



<?php
include"conifig.php";
$password=$_POST['password'];
$user = $_GET['username'];

$pass=md5($_POST['password']);

if(mysql_query("UPDATE `table` SET `Password` = '$pass' WHERE `Loginname` = '$user' "))
echo "Your password successfully changed";
else
echo "Failed to change your password.";

mysql_close($con);

?>


Not quite sure about the "`meconzee1_user` Loginname" part.
You need to find out what field you want to compare.