PHP/SQL UPDATE QUERY

Hello, I am new here and I am doing some personal project. the problem I have is that i am trying to update my database through a form but to no avail, can someone help please?

These are parts used for the update code:
//index.html The problem i think its in this part ***
$result = new dataclass();
$result->updateMember2
(
$_POST[“txtHidden”],
$_POST[“MemberName”],
$_POST[“MemberSurname”],
$_POST[‘MemberUsername’],
$_POST[“MemberEmail”],
$_POST[“MemberPassword”]
);

//dataclass.php
function updateMember2($memberID, $name, $surname,$username, $email, $password)
{
echo(“update tblmembers
set MemberName=’$name’, MemberSurname=’$surname’,MemberUsername=’$username’,
MemberEmail=’$email’, MemberPassword=’$password’
where idtblMembers = $memberID”);

//test2.php
function update() {
if(isset($_GET[‘updateid’]))
{
echo ‘

’;
echo “";
while($record = mysql_fetch_assoc($this->dataset))
{
$COUNT=0;
if($record[$this->itemID] == $_GET[‘updateid’])
{
foreach($this->fields as $field => $value)
{

echo “

";
//echo “"’;
PRINT_R($this->fields[$field]);
ECHO’’;

}
}
}

echo ’

<input name=‘txtHidden’type=‘hidden’ value=’”. $_GET[‘updateid’] ."’ />
”.$this->fields[$field]." <input name=’.$this->fields[$field].‘type=‘text’ value=’ $record[$value]’ />
”.$this->fields[$field]." <input name=’.$this->fields[$field].‘type=‘text’ value=’";
//echo $record[$value];
//echo’ />
’;

}

}

//PRINT_R ***
update tblmembers set MemberName=’’, MemberSurname=’’,MemberUsername=’’, MemberEmail=’’, MemberPassword=’’ where idtblMembers = 40

OKdataclass Object ( ) Array ( [txtHidden] => 40 [_Array] => Array ( [MemberName] => txtName [MemberSurname] => txtSurname [MemberUsername] => txtUsername [MemberEmail] => txtEmail [MemberPassword] => txtPassword ) )

Only the id is getting through to the sql as u can see from the POST_R

Can you please help me out with this problem? cheers

I am really lost…

Sponsor our Newsletter | Privacy Policy | Terms of Service