So I'm doing a project just for the heck of it. However, I'm stuck on an issue. I want to query the database to select the last comment in the answers table so I can display it on the main forum page under the specified topic. How do I do this? if it helps I can display the database data for the table field:
CREATE TABLE IF NOT EXISTS `answer` ( `question_id` int(4) NOT NULL DEFAULT '0', `a_id` int(4) NOT NULL DEFAULT '0', `a_name` varchar(65) NOT NULL DEFAULT '', `a_email` varchar(65) NOT NULL DEFAULT '', `a_answer` longtext NOT NULL, `a_datetime` varchar(25) NOT NULL DEFAULT '', KEY `a_id` (`a_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
I know this is probably really simple for a lot of you all but I am seriously stuck and can't seem to figure it out. Can anyone help me in the right direction? Thanks in advance!