MySQL UPDATE doesn't work...

sck8000 · December 19th, 2008, 06:00 AM

I'm having a problem with the MySQL UPDATE for changing user details on my website, bronzephoenix.net . The code I'm using is:

Code:


			
<?php 
$biography = $_POST['biography'];
$pass = $_POST['password'];
$email = $_POST['email'];
$name = $_COOKIE['logged'];
 
require_once('Connections/bronzeph.php');
mysql_select_db($database_bronzeph, $bronzeph);
$query_Recordset1 = "SELECT * FROM userData WHERE name='$name'";
$Recordset1 = mysql_query($query_Recordset1, $bronzeph) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
 
$row = mysql_fetch_array(mysql_query($query_Recordset1));
mysql_query(" UPDATE userData SET password=$pass, email=$email, biography=$biography WHERE name=$name ");
$message = "Your details have been changed to:<br><br>Email: ".$row['email']."<br>".$row['password']."<br><br>".$row['biography']."";
header("Location: http://www.bronzephoenix.net/message.php?message=".urlencode($message)."");
mysql_free_result($Recordset1);
?>

It goes to the message page, but doesn't change any details. Please help!

Aso · December 19th, 2008, 06:25 AM

You need to quote values in your UPDATE query;

Code:

mysql_query("UPDATE userData SET password = '$pass', email = '$email', biography = '$biography' WHERE name = '$name'");

sck8000 · December 19th, 2008, 07:18 AM

Quote:

Originally Posted by Aso

You need to quote values in your UPDATE query;

Code:

mysql_query("UPDATE userData SET password = '$pass', email = '$email', biography = '$biography' WHERE name = '$name'");

Thanx