php current location ID

[nadi]

Picture1.png (65 KiB) Viewed 257 times

how to get the current location for student. base on id.
as u can see from my table which is Arnold current location is no 3 and krish is no 4.
let say i delete the Arnold then krish will replace the current location of Arnold is no 3.

kindly please advise.


sorry for ma bad eng.

[seandisanti]

You know what you want, just ask the database for it. There are several ways to query the database and i'll let you pick your favorite, but your sql query will be something like:

Code: Select all

SELECT id from table where name='Whatshis Face'

Where whatshis face is the name of the person whose id you want returned.

[nadi]

ai thank...but i still blur and don't get it, i try using as below but it juz show id number...what i need give id become continues number.
in my table u can see some id number got 14, 31,32....
and i want to display it will be exactly like 1,2,3,4......for 14 it will be no 6, 31 will be no 7...


i try search by how to get my current location query..but i think i make it wrong..


please correct me..^_^..

[seandisanti]

I'm sorry if i'm not understanding, but I think what you're looking for is ORDER BY. so your query (assuming you're doing a select all, would be like:

Code: Select all

SELECT * FROM table WHERE condition=true ORDER BY id ASC