Coding a update email address

mccloud

<?php
// session level
$query = "SELECT * FROM players WHERE id = \"".$SESSION["xpl_gfx_suserid"]."\"";
if($SESSION["xpl_gfx_slevel"] >= "1")
{
// session level > 1
// posting variables
$POST = valid_post($POST);

$ci_email = $_POST['ci_email'];


$query = "UPDATE `players` SET `ci_email` = '$ci_email' WHERE `id` = \"".$_SESSION["xpl_gfx_suserid"]."\"";
$result = mysql_query($query);

Can you guys help me with this one?? Please and thank you.

Kudose

<?php
// session level
$query = "SELECT * FROM players WHERE id = '".$_SESSION["xpl_gfx_suserid"]."'";
if((int)$_SESSION["xpl_gfx_slevel"] >= 1)
{
// session level > 1
// posting variables
$_POST = valid_post($_POST);

$ci_email = $_POST['ci_email'];

$query = "UPDATE players SET ci_email = '$ci_email' WHERE id = '".$_SESSION["xpl_gfx_suserid"]."' LIMIT 1";
$result = mysql_query($query);

echo ($result) ? 'success' : 'failure'; 
} else {
echo 'Unauthorized.';
}
?>

mccloud

Kudose wrote:

<?php
// session level
$query = "SELECT * FROM players WHERE id = '".$_SESSION["xpl_gfx_suserid"]."'";
if((int)$_SESSION["xpl_gfx_slevel"] >= 1)
{
// session level > 1
// posting variables
$_POST = valid_post($_POST);

$ci_email = $_POST['ci_email'];

$query = "UPDATE players SET ci_email = '$ci_email' WHERE id = '".$_SESSION["xpl_gfx_suserid"]."' LIMIT 1";
$result = mysql_query($query);

echo ($result) ? 'success' : 'failure'; 
} else {
echo 'Unauthorized.';
}
?>

That didn't work man

SpecialFX

So first off, you never do anything with the first query variable, you never actually execute the select you need to insert a mysql_query() function afterward and then do whatever you were going to do with that selected data. Secondly, is valid_post() a custom function you wrote? If so there is no include of it being in another file, because valid_post() isn't an actual function.

Weedpacket

And when you posted you never gave any indication of what the problem was or what you'd found out about it while debugging.

mccloud

Weedpacket wrote:
And when you posted you never gave any indication of what the problem was or what you'd found out about it while debugging.

Im new to this okay the issue taht i can see it will say it was updated but it wasnt updated at all i wanna know why and how to fix it just work with me please.