2. PHPRunner General questions
  3. Multiline list page
This topic is locked

Multiline list page

 		7/19/2007 8:14:10 AM
PHPRunner General questions
I
 itxlieni author

Hello
I work with the php version 3.1

i have 2 Tables users and groups,

I add a multiline lookup table box on the add page, multiple selection works fine, but wenn i return to the list page or export the list,

only the first selection is displayed.
In the table "users" i have a fiel usergroup linked to the table "groups" field ID (Master-Detail works fine)

In the table "groups" i have the Fields ID (auto incremental) and usergroup (textfield)
What can i do to get the full content of this selection?
Thanks for your Solution
Greets from Switzerland
J
 		Jane 7/20/2007

Hi,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
I
 		itxlieni author 7/30/2007

Hi Jane
I have 2 Tables users and usergroup.

The Problem is when i select multiple usergroup on the users_edit page everything is ok. Also in the mysql-db.

When i return to the users_list page, only the first selected record is displayed in the field usergroup.
Edit Page


List Page


I have a Site usergroup_list, to display each user on any selected usergroup, xlinesoft tells me to ad the following mysql query to the users_list.php file. This for displaying the records with multiple selection on each page (usergroup). This works fine also.
$mkey=$_SESSION[$strTableName."_masterkey1"];

$where.= "(usergroup='".$mkey."' or usergroup like '".$mkey.",%' or usergroup like '%,".$mkey.",%' or usergroup like '%,".$mkey."')";
Thanks for your Help, an the great work on the next Version 4.1
Oliver