Hey everyone,
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!
-Geneh23