List Info

Thread: more php help needed




more php help needed
country flaguser name
United States
2008-03-27 19:38:03

Okay, I got the first error from yesterday figured out (Thanks Rob - it was
a variable problem.)

Now I have a new one. Here's the relevant code:

function escape_data($data) {
global $connection;
if (ini_get('magic_quotes_gpc')) {
$data = stripslashes($data);
}
return mysql_real_escape_string($data,$connection);
}

$u = $_POST['user'];
$e = "'" .escape_data($_POST['email']) ."'";
$p = "'" .$_POST['new_pass'] ."'";

// sql statement to enter email & password to db

$sql = "REPLACE INTO $table_name(email,password) VALUES ($e,$p) WHERE
user_id = " .$u;

$result = mysql_query($sql, $connection) or die(mysql_error());

Any help would be greatly appreciated.

Terri

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )