Thank you soshite, I’ll try it and let you know. Nice site, by the way!
EDIT: Weird...if I leave the Bio field blank and edit my profile, the script wipes it out from the database. I wonder why it’s doing that?
<a href="http://www.thisisafakeurl.com">Fake Fanlisting</a><br />
☆ A M B ☆
Hi there,
Before I ask my question, is there a separate PPP forum anywhere?
I’m using PPP for some simple user accounts and I wanted to display a Member List that shows everybody who’s signed up to the site so far, which is displayed in date order having the newest member at the top...
Does anyone know a way of doing this?
Thanks, Mallmus
//Will rewrite so that only fields (placeholders) that are in the template chunk will be seleced in the query
if (!EMPTY($tableToUse)) {
$sql = 'SELECT u.username, a.*, c.*, g.*, n.*, au.lasthit FROM ' . $table_users . ' u';
$sql .= ' INNER JOIN ' . $table_attrib . ' a ON u.id = a.id';
$sql .= ' INNER JOIN ' . $table_wg . ' g ON u.id = g.webuser';
$sql .= ' INNER JOIN ' . $table_wg_n . ' n ON g.webgroup = n.id';
$sql .= ' LEFT OUTER JOIN ' . $table_au . ' au ON u.username = au.username';
$sql .= ' RIGHT OUTER JOIN ' . $table_custom . ' c ON u.id = c.webuser';
} else {
$sql = 'SELECT u.username, a.*, g.*, n.*, au.lasthit FROM ' . $table_users . ' u';
$sql .= ' INNER JOIN ' . $table_attrib . ' a ON u.id = a.id';
$sql .= ' INNER JOIN ' . $table_wg . ' g ON u.id = g.webuser';
$sql .= ' INNER JOIN ' . $table_wg_n . ' n ON g.webgroup = n.id';
$sql .= ' LEFT OUTER JOIN ' . $table_au . ' au ON u.username = au.username';
}//Will rewrite so that only fields (placeholders) that are in the template chunk will be seleced in the query
if (!EMPTY($tableToUse)) {
$tables = 'a.*, c.*, g.*, n.*';
$finalJoin = ' RIGHT OUTER JOIN ' . $table_custom . ' c ON u.id = c.webuser';
} else {
$tables = 'a.*, g.*, n.*';
$finalJoin = '';
}
$sql = 'SELECT u.username, ' . $tables . ', au.lasthit FROM ' . $table_users . ' u';
$sql .= ' INNER JOIN ' . $table_attrib . ' a ON u.id = a.internalKey';
$sql .= ' INNER JOIN ' . $table_wg . ' g ON u.id = g.webuser';
$sql .= ' INNER JOIN ' . $table_wg_n . ' n ON g.webgroup = n.id';
$sql .= ' LEFT OUTER JOIN ' . $table_au . ' au ON u.username = au.username';
$sql .= $finalJoin;