From: Hans T. <h.t...@st...> - 2002-08-27 10:14:12
|
Hi, i've installed PhpMyEdit 4.0b3 without any problems. However since the install manual (on http://phpmyedit.sourceforge.net/) is for the 3.5 version (i think), I can't get the multi table function to work properly. When I use the multi table function from the examples: $fdd['GID']['values']['table'] = 'Groups'; $fdd['GID']['values']['column'] = 'GID'; $fdd['GID']['values']['description'] = 'description'; the result is a dropdown list from the 2nd table. When I select Change, the original value is not preselected. The html code does not show '<option SELECTED>' The second question is how to lookup 2 values from a 2nd table ? If I have a table (News) which includes an user id (UID) and I want to lookup the name from another table (Users) I have to choose between the first (Name1) or last name (Name2). How can I show both first and last name in a dropdown field (like Name1,Name2) ? table News: ID -> unique autoincr. field Newstype -> varchar (20) .... UID -> int(4) table Users: UID -> unique autoincr. field, int(4) Name1 -> varchar (20) Name2 -> varchar (20) .... Hans |