help with new members

[onthespot]

could anyone help me! i need to display the latest members that have joined my site! what is the best way to go around doing this?

[makeshift_theory]

Well assuming your storing them a mysql database...When you do your search query to your mysql database just do ASC and that should give you the newest entry.

[onthespot]

could you provide code for this mate?? my members are stored in database with their id's! surely the newest idea would be the latest member?

[appeland]

To help you we need to know what product you are using to realize your site.

[AndyB]

Assuming that you are actually storing the data in a MySQL table ... SELECT * from members_table ORDER by id DESC LIMIT 5

That sort of sql query will give you the five (limit) records with the 5 highest ids, ordered from highest to lowest.

[onthespot]

thankyou andy, so if i change limit to 20, i will get last 20??

[BillyBoB]

this is true

[onthespot]

ty all

[onthespot]

ok im unsure of how to execute this! ive got to this part now, and dont understand it!
i have a line in my html script where i want to insert "SELECT * from users ORDER by id DESC LIMIT 5"

could you tell me exactly how to put this in?

[onthespot]

  echo "<td>" . echo $row['FirstName'] . "</td>";
  echo "<td>" . echo $row['LastName'] . "</td>";

with those two lines im getting this error:

Parse error: parse error, unexpected T_ECHO

any ideas?

[Jeremysr]

You only need to echo once:

echo "<td>" . $row['FirstName'] . "</td>";
echo "<td>" . $row['LastName'] . "</td>";