I was wondering how to go about displaying the last <enter number here> of members to sign up to the site on a page
eg like if you set it to 10 it would display something like
Newest Members to join the site:
1 <membername> 6 <membername>
2 <membername> 7 <membername>
3 <membername> 8 <membername>
4 <membername> 9 <membername>
5 <membername> 10 <membername>
tho I have no clue how to pull it from the database and display it any help appriciated 😉
~Spikey~
my site url: http://www.fanfictionworld.org
efic version:3.5.3
From a PHP newbie's point of view; with no knowledge of eFiction. (or apparent knowledge because I don't like tinkering with these type of scripts ;))
(from the top of my head)
<?php
$result = mysql_query("SELECT * FROM fanfiction_authors ORDER BY uid DESC LIMIT 10");
echo "<ol>";
while($story = mysql_fetch_array($result)) {
?>
<li><a href=""viewuser.php?uid=<?php" echo $story[uid]; ?>"><?php echo $story[penname]; ?></a></li>
<?php
}
?>
You'll have to eFic that ... (or wait for someone else to help you :))
I believe it's:
mysql_query = dbquery
mysql_fetch_array = dbrow
But I'm not sure.
archive:
site:
Available for skin/mod commission! 🙂
yeah I'll wait untill someone else efic's it for me as im not sure how to do it tho im sure someone will know how! but thanks for the input Jenny 😀
~Spikey~
my site url: http://www.fanfictionworld.org
efic version:3.5.3
I'm interested in this, too. If this ever gets "eFicced," I'd like to know about it.
Matter of fact, I wonder if there's a way to alter the {newest} variable so it displays more than one member, like you can set the number for it to display.
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
