i can query the list fine using:
-
select list.list, many_table.list_id_fk from list left join many_table
-
on list.id = many_table.list_id_fk and many_table.userid = 'UserId';
-
that populates the list per user id.
now when the user selects a new item from the list
it does not update
here is the update query:
-
$updateSQL = sprintf("UPDATE list_many SET list_many_id_fk=%s, UserIdFk='1', `Date`=now() WHERE Id=%s",
-
GetSQLValueString($_POST['list_many_idfk'], "int"),
-
GetSQLValueString($_POST['UserIdFk'], "int"),
-
GetSQLValueString($_POST['Date'], "date"),
-
GetSQLValueString($_POST['Id'], "int"))
-
sorry posted in php; its mysql issue.
thanks in advance for your help!
theo
