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 />
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;