[SOLVED] newest member sign up from database

[jaimeweb]

Hi...Right this may be hard to explain becuase i am not any good with mysql...but i have a website and i have a mysql database of which people sign up to my website and then i can view all the users...

 

Now i want to add something on my website which says "newest member: *their username*"

So it takes the username from the mysql table of the newest entry...is this possilbe and how?!!?!?!

 

Please explain in detail.....thank you so much in advance

[jaimeweb]

anyone?

[Shirik]

Show the structure of the table? Do you have an primary key/auto_increment column? If so, couldn't you just do something like

 

SELECT username FROM members
ORDER BY id
LIMIT 1;

 

Also, SELECT LAST_INSERT_ID(); works but I don't think it will work for your purposes, I'm afraid.

 

Alternatively, add a column to store the date/time of join, then order on that instead of id (same query as above).

 

[jaimeweb]

Hi Shirik thanks for your comment.

Right as for this bit:

 

SELECT username FROM members
ORDER BY id
LIMIT 1;

 

I would have no idea of how to insert that on my PHP webpage...so would you be able to write it so i could just copy it in...(obviosuly changing the parts i need to)

 

And yes i do have a auto_increment column......i think...anyway..ive added a screenshop of my database in phpmyadmin...Please get back to me thanks so much again

 

[attachment deleted by admin]

[jaimeweb]

Please help!

[genics]

Something like this?

 

<?php
$latestUser = "SELECT id, uid FROM table_name ORDER BY id DESC LIMIT 1";
$result = mysql_query($latestUser ) or die(mysql_error());
while(list($id, $uid) = mysql_fetch_array($result, MYSQL_NUM))
{	
?>
<p>Newest Member: <?php echo $uid; ?></p>
<?php
}
?>

[genics]

Replace

table_name

 

With your actual table name.

[jaimeweb]

Hi genics thanks for the reply...im gettin this message when i go on my webpage...ive typed the table name in...

 

 

 

 

Warning: mysql_query() [function.mysql-query]: Access denied for user: 'nobody@localhost' (Using password: NO) in /data01/owlsfan/public_html/try.php on line 3

 

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /data01/owlsfan/public_html/try.php on line 3

Access denied for user: 'nobody@localhost' (Using password: NO)

[jaimeweb]

Another thing...when you say Table_name...what do you mean...the actaul table name? because that is just "users"...but then how does the code know to pick it from which database becuase the database is called "owlsfan_simp" which consists of one table which is "users"

 

Thanks

[Waldir]

you need to connect to the database

 

      /* Make connection to database */
      $connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die('Couldnt Connect to the database');
      mysql_select_db(DB_NAME, $connection) or die(mysql_error());

 

replace:

DB_SERVER, DB_USER, DB_PASS, DB_NAME

 

with the corresponding information

[genics]

Yep, as waldir pointed out - you need to connect to the database in order for my script to work.

 

Your strcuture will be:

 

database

-> table

---> user

 

So you need to first connect to your database with the following script:

 

$host = "server";
$user = "username";
$pass = "password";
$database = "database_name";

$connect = mysql_connect($host, $user, $pass) or die('Connection Failed');
mysql_select_db($database) or die(mysql_error());

 

Then you need to select the table and relevant fields from the database:

 

<?php
$latestUser = "SELECT id, uid FROM table_name ORDER BY id DESC LIMIT 1";

 

And then finally you need to display those selected fields:

 

$result = mysql_query($latestUser ) or die(mysql_error());
while(list($id, $uid) = mysql_fetch_array($result, MYSQL_NUM))
{	
?>
<p>Newest Member: <?php echo $uid; ?></p>
<?php
}
?>

 

So to put it all together:

 

<?php
$host = "server";
$user = "username";
$pass = "password";
$database = "database_name";

$connect = mysql_connect($host, $user, $pass) or die('Connection Failed');
mysql_select_db($database) or die(mysql_error());

$latestUser = "SELECT id, uid FROM table_name ORDER BY id DESC LIMIT 1";
$result = mysql_query($latestUser ) or die(mysql_error());
while(list($id, $uid) = mysql_fetch_array($result, MYSQL_NUM))
{	
?>
<p>Newest Member: <?php echo $uid; ?></p>
<?php
}
?>

 

So for you to get my script to work, you need to edit all the bits:

 

- server

- username

- password

- database_name

- table_name

[genics]

Another thing...when you say Table_name...what do you mean...the actaul table name? because that is just "users"...but then how does the code know to pick it from which database becuase the database is called "owlsfan_simp" which consists of one table which is "users"

 

Thanks

 

The table name is the name of the table you posted a screenshot of. If that's called users then just replace table_name with users

[jaimeweb]

OMG, thanks so much..it works ...thanks very much for your help! 

[genics]

No problem mate.

 

Remember to mark this as solved.