Some questions needing answers plz!

[Francky683]

Hi guys,
I'm currently working on a new website and I planned on making it with PHP/mySQL ... I made some coding but there are questions I can't find any answers ... so I'm asking u guys 😉

1. I wanna see who's the latest guys that subscribed on my site ... I do insert the time when the guy's registering ... so what's the code to use to display the lastest one that subscribed???

2. I wanna see what's the latest clan that subscribed ... but the prob is that some of my rows in my table won't have nothing in the 'clan' column cuz then don't have 1 ... how could I do this ???

3. I'm displaying the clans subscribed but when I have like 5-6 times the same one it's displaying 6 times it ... how could i only show the clan 1 time ???

That's about it for now ....

Thanks alot!,

~Francky683~

[laserlight]

1. Yes, recording the time is possible.
   It is also possible to simply retrieve the last row of say, the users table.

2. Not sure, you need to show your database schema to know what data you're recording and where.

3. It depends.
   Since you're using mysql, you can search mysql.com docs on SELECT DISTINCT

[Francky683]

k ... since its possible could you gimme the codes :eek: :p

PLZZZZZZZZZZZZZZZZZZZZZ 🙂

Here whats my DB looks like :

id
username
lastname
clanname
clantag
location
age
(...)

clanname can be blank or can be filled my the user ... so i only want to see the last clanname where there is sumthing written ...

[laserlight]

Try to figure things out yourself first.
Searching the mysql manual would be a good idea.
Still, one way to do it would be:

SELECT columns FROM tablename ORDER BY table_id DESC LIMIT 1

where columns would be the fields required from table tablename.
table_id would be the primary key, probably INT NOT NULL AUTO_INCREMENT
DESC means we order in descending order, and LIMIT 1 means we only take the 1st record in this order, i.e. the last record.

Another way might use [man]mysql_insert_id/man, but that's another matter.

[Francky683]

k thx ... I updated my other post, anything usefull there?

[laserlight]

Well, it might make more sense to place clans in a separate table.

It looks like users and clans have a many-one relationship.

users table

user_id
clan_id
username
lastname
location
age

clans table

clan_id
clanname
clantag

So to look up which clan a user is in, you check his/her clan_id, then check the clans table for the corresponding clan_id

[Francky683]

thx buddy :p