this is my function. it takes post data from a form and is supposed to update the database with that information....
global $EvSystem, $EvDB, $guid;
$Cguid = $guid;
$sql = "UPDATE users
WHERE id = '".$Cguid."'
$result = $EvDB->query($sql)or die(mysql_error());
echo 'Update Successful!';
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?
UPDATE users SET username='test', firstname.lastname@example.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?
"Knowledge is power. Abuse it."~Evulness
My portfolio: www.evularts.com