A query which can select the last entry

[ovisopa]

Hello ppl,

I have a question for all yo: can I make a query which can read the last added entry from a table? I don't have a timestamp column, is this a problem?

I want to make a script that shows me the last post, I saw that some where an it was showing the last post from that forum.

..
and another question 🙂 How can I retrive the ip of my visitors when they submit a form from my page?

The form is sending to my adress name, email adress, and coments but I want the ip to and ... maibe the time when the form was sent.

10x a lot ... see ya soon

[archangel_617b]

Please speak in english. It really helps articulate your problem making easier for other to help you. Especially since many here are not native english speakers anyhow.

---

You should add a unique id field to every table in your database. They are very useful and this is one case. It should look like this in sql:

id int auto_increment,
primary key(id)

You can then order on that field like this:

SELECT * FROM table ORDER BY id DESC LIMIT 1;

---

$_SERVER['REMOTE_ADDR'];

I think that's where the IP is. REMOTE_ADDR is definately the field. you can find it in the manual if I am wrong.

---

To see the time of their post, you will need a datetime field in your db. Setting is easy though:

INSERT INTO table (time) VALUES (NOW());

Voila!