problem with Update query (variable)
Posted: Tue Jan 06, 2004 1:24 pm
Hi !
I need some help, I've been stuck on this for hours . This code works well to update a data in mysql :
<html>
<head>
<title>Password Entry Results</title>
</head>
<body>
<h1>Password Entry Results</h1>
<?php
// create short variable names
$id = "";
$login=$HTTP_POST_VARS['login'];
$passe=$HTTP_POST_VARS['passe'];
$npasse=$HTTP_POST_VARS['npasse'];
$npasse2=$HTTP_POST_VARS['npasse2'];
if (!$login || !$passe || !$npasse || !$npasse2)
{
echo 'You have not entered all the required details.<br />'
.'Please go back and try again.';
exit;
}
if ($npasse !== $npasse2)
{
echo 'You have made a mistake while entering the passwords.<br />'
.'Please go back and try again.';
exit;
}
$id = addslashes($id);
$login = addslashes($login);
$passe = addslashes($passe);
$npasse = addslashes($npasse);
@ $db = mysql_pconnect('localhost', 'root', '');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db('mailelani') or exit("Could not connect");
$query = 'UPDATE `passe` SET `passe` = ''patapouf'' WHERE `login` = ''fuerim1'' LIMIT 1 ;'
. ' ';
$result = mysql_query($query);
echo $result ." password modified";
?>
</body>
</html>
but if I try to use variables, it doesn't :
$query = 'UPDATE `passe` SET `passe` = $npasse WHERE `login` = $login LIMIT 1 ;'
. ' ';
$result = mysql_query($query);
what I am doing wrong ????
Thanks for your help, I'm getting crazy !
I need some help, I've been stuck on this for hours . This code works well to update a data in mysql :
<html>
<head>
<title>Password Entry Results</title>
</head>
<body>
<h1>Password Entry Results</h1>
<?php
// create short variable names
$id = "";
$login=$HTTP_POST_VARS['login'];
$passe=$HTTP_POST_VARS['passe'];
$npasse=$HTTP_POST_VARS['npasse'];
$npasse2=$HTTP_POST_VARS['npasse2'];
if (!$login || !$passe || !$npasse || !$npasse2)
{
echo 'You have not entered all the required details.<br />'
.'Please go back and try again.';
exit;
}
if ($npasse !== $npasse2)
{
echo 'You have made a mistake while entering the passwords.<br />'
.'Please go back and try again.';
exit;
}
$id = addslashes($id);
$login = addslashes($login);
$passe = addslashes($passe);
$npasse = addslashes($npasse);
@ $db = mysql_pconnect('localhost', 'root', '');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db('mailelani') or exit("Could not connect");
$query = 'UPDATE `passe` SET `passe` = ''patapouf'' WHERE `login` = ''fuerim1'' LIMIT 1 ;'
. ' ';
$result = mysql_query($query);
echo $result ." password modified";
?>
</body>
</html>
but if I try to use variables, it doesn't :
$query = 'UPDATE `passe` SET `passe` = $npasse WHERE `login` = $login LIMIT 1 ;'
. ' ';
$result = mysql_query($query);
what I am doing wrong ????
Thanks for your help, I'm getting crazy !