Link with a unique ID

Question

There is a table in the database, each element of the table is displayed on the pages in a loop with a unique id, it turns out like this: Ivan, Andrei, Anton, the names are links to the message, that is, the message from Ivan is stored in the database. Ivan ", opened the page with the message. How to implement correctly? _ _ _ _ _ _ _ __-

id of message whom email 1 azon Почему меня забанили? admin 2 anna За что меня забанили?? admin angers@mail.ru 3 addon Я не нарушал правил! admin angers@mail.ru

Mm .. I just understood that the id varchar field contains user names, I wanted to clarify this.
varchar id is not the best option: it runs faster by numbers.
Although it is impossible to completely exclude the possibility of use, but most often there is a hash in this case.

knes knes 24.8k 31 65 · Accepted Answer · 2012-07-24T10:45:12

users:

messages

Message_id | User_id | text

Normalization is our all. =)

 //Выборка сообщений 'Select `text` from `messages` where `user_id`='.intval($_GET['id']); // //Выборка ссылок $res = mysql_query('select `USER_ID`,`USER_NAME` from `users`'); while($row = mysql_fetch_object($res)){ pritf('<a href="?id=%d">%s</a>',$row->USER_ID,$row->USER_NAME); }

Not needed, if the sample will always be for ALL user messages.

Link with a unique ID

1 answer 1

More articles: