syntax problem

Evulness · 07-29-2008, 05:49 PM

this is my function. it takes post data from a form and is supposed to update the database with that information....

Code:

function DoUpdate(){
global $EvSystem, $EvDB, $guid;
$Cguid = $guid;
$id =$EvSystem->Clean($_POST['id']);
$username =$EvSystem->Clean($_POST['username']);
$email =$EvSystem->Clean($_POST['email']);
$fname =$EvSystem->Clean($_POST['first_name']);
$lname =$EvSystem->Clean($_POST['last_name']);
$packet1 =$EvSystem->Clean($_POST['packet1']);
$packet2 =$EvSystem->Clean($_POST['packet2']);
$comment =$EvSystem->Clean($_POST['comment']);

$sql = "UPDATE users
        SET username='".$username."',
        email='".$email."',
        first_name='".$fname."',
        last_name='".$lname."',
        packet1='".$packet1."',
        packet2='".$paket1."',
        comment='".$comment."'
        WHERE id = '".$Cguid."'
        ";

$result = $EvDB->query($sql)or die(mysql_error());
if($result){
echo 'Update Successful!';
}
else{
echo 'Update NOT successful!';
}
}

$guid is set to equal the$_GET of the incoming url, which in turn is supposed to be used in the where. but when i print my query, all the data shows except the where id... i have guid defined at the begining of the script, to be set when a get['guid'] was present.... this should be working shouldn't it?

Quote:

UPDATE users SET username='test', email='test1@nffsolutions.org', first_name='test', last_name='testie', packet1='sent on 7/25', packet2='', comment='Updated! vdfgfg' WHERE id = ''

the thing is... is i get no errors, no warnings, nothing.... it runs and says it was successful, but when i view the table, it isn't updated...

any ideas whats going on?

Evulness · 07-29-2008, 08:16 PM

never mind... i wrote that before lunch and fixed it when i got back here...
it wasn't sending my ID, because i wasn't sending the id via post anymore, once it got to that point...
i had it to just echo the id, nor echo a hiden input with the id & number to be post.

works fine now :)