Code
$myUid= "30";
$myBio= "I went to school once bla bla bla bla";
$userscolumn = $pntable['users_column'];
$userstable = $pntable['users'];
$sql = "UPDATE $userstable
SET $userscolumn[bio] = " . pnVarPrepForStore($myBio) . "
WHERE $userscolumn[uid] = " . pnVarPrepForStore($myUid) . ";
$dbconn->Execute($sql);
$myBio= "I went to school once bla bla bla bla";
$userscolumn = $pntable['users_column'];
$userstable = $pntable['users'];
$sql = "UPDATE $userstable
SET $userscolumn[bio] = " . pnVarPrepForStore($myBio) . "
WHERE $userscolumn[uid] = " . pnVarPrepForStore($myUid) . ";
$dbconn->Execute($sql);
I use a simillar SQL call to initially add the user to mysql and it works fine. but with this I get no error but the data does not get added. I have not been able to find a example of how to better do this. any help would be great.
dave
