Form Variable in PDO Query?

$_POST'amount' : null; if (null === $amount) { throw new Exception('Amount not set'); } $user = 'user'; $pass = 'pass'; if (empty($_SESSION'MM_Username')) { throw new Exception('Username table not set in session'); } $pdo = new PDO('mysql:host=localhost;dbname=dbname', $user, $pass); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $query = sprintf('UPDATE `%s` SET `stock` = :amount WHERE `status` = 1', $_SESSION'MM_Username'); $stmt = $pdo->prepare($query); $stmt->bindParam('amount', $amount); $stmt->execute(); } else { echo 'Nothing to do'; }.

Ok will try these two possibilities and get back to you. – Parker Oct 22 '10 at 4:34 Finally got it Phil! Form variable amount was not being set correctly due to having two forms with identical names on the same page.

I cannot thank you enough for your help this evening. Have a great Night! – Parker Oct 22 '10 at 4:49 FYI - The form "name" attribute is useless.

– Phil Oct 22 '10 at 4:50 While table name supposed to be secure, it's still very bad and highly dangerous practice to add data to the query this way. You lose all PDO benefits at once. I would check table existence with another query first.

Or, even better, would not use named tables at all. – Col. Shrapnel Oct 22 '10 at 6:03.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.