[TheMaster]

This very much depends in how you are inserting the users into the user table. Whenever I am making a signup system - I have a "join_date" column in the table, so that I can do something like this.

If you dont, I would suggest adding one. The following could might still work without a date field though:

This outputs latest 5 users to have joined.

$query = mysql_query("SELECT user FROM users ORDER BY id desc LIMIT 5");

while ($row = mysql_fetch_array($query)) {

echo $row['user'] . '<br>';

}

Are you using PDO? If so just tell me so I can 1) Cheer, and 2) Change the code to make it work with that!

[goldenpages]

TheMaster, on 17 August 2012 - 06:26 PM, said:

This very much depends in how you are inserting the users into the user table. Whenever I am making a signup system - I have a "join_date" column in the table, so that I can do something like this.

If you dont, I would suggest adding one. The following could might still work without a date field though:

This outputs latest 5 users to have joined.

$query = mysql_query("SELECT user FROM users ORDER BY id desc LIMIT 5");

while ($row = mysql_fetch_array($query)) {

echo $row['user'] . '<br>';

}

Are you using PDO? If so just tell me so I can 1) Cheer, and 2) Change the code to make it work with that!

i am using pdo

[TheMaster]

Are you using mySQL?

[goldenpages]

For some reason, when i execute the code below, it only echo's the first record in the table, not all of them:

<?php

try 

{

$conn = new PDO("mysql:dbname=users;host=localhost", "register", "mysql" );

$sql = $conn->prepare("SELECT * FROM users");

$sql->execute();

$result = $sql -> fetch(); 
 
echo $result ["FirstName"] . " " . $result ["LastName"]; 

$conn = null;

}

catch(PDOException $e)
{
echo $e->getMessage();
$conn = null;
}

?>

[TheMaster]

You need to change the fetch() line to:

while ($result = $sql -> fetch()) {
echo $result ["FirstName"] . " " . $result ["LastName"];
}