Inner join

Databases
1

This is the result I get from
SELECT * FROM messages
http://coronadoshores.ca/admin/list_messages.php
I want the topic to be the actual topic and not its id, since im kind of new to joins, is this the best way?
SELECT messages.mess_id, messages.topic_id, messages.subject, messages.display, messages.created, messages.message_txt,
topics.topic
FROM messages
INNER JOIN topics
ON messages.topic_id = topics.topic_id;

1920×1080 382 KB

(attached is the topics table in phpmyadmin)

2

yes

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.