2. PHPRunner General questions
  3. How to in group members show others columns
This topic is locked

How to in group members show others columns

 		2/16/2008 11:41:30 AM
PHPRunner General questions
R
 Rigmantas author

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7579&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' /> Nice to help from your.

Rimantas

Thanks
J
 		Jane 2/18/2008

Rimantas,
use GROUP BY clause in your SQL query for this purpose.
R
 		Rigmantas author 2/20/2008

Sorry,

You don't read my question, or don't understand.

Rimantas
J
 		Jane 2/21/2008

Please re-phrase your question.
R
 		Rigmantas author 2/21/2008

Please re-phrase your question.



In adminpage where i can assign users to groups, in user column i want se name, surname and other information from users table.

Thanks
Alexey admin 2/22/2008

Rimantas,
you can modify generated admin_members.php file for this
At first modify this line to add fields you need to SQL query:

$gsqlHead="select Username, Surname, Lastname, Firstname ";



Then this one to display data on the page:

$row["username"]=htmlspecialchars($data["Username"]." ".$data["Lastname"]);

See my changes in bold.
A
 		amplus 2/22/2008

Rimantas,

you can modify generated admin_members.php file for this
At first modify this line to add fields you need to SQL query:
Then this one to display data on the page:

See my changes in bold.


How can I change this in the UG_members.php, so I have to this only once.
Alexey admin 2/22/2008

Hi,
exactly the same way.

Modify lines that start with

$gsqlHead="...

and

$row["username"]=..
A
 		amplus 2/22/2008

Hi,

exactly the same way.

Modify lines that start with

and


Alexey,
thanks it works great !