Ok I'm trying to build a forum site. I have multiple tables representing the different categories that the user can select from. I'm working on the head page and what I want to do is retrieve the 10 last most recent comments posted across all tables. I want to use the time stamp that I have created BUT i'm not sure if i'm using the most efficent coding to record time. This is what I'm using.
$tablename='sports'; $topic=$_POST['topic']; $comment=$_POST['comment']; $username=$_POST['username']; $date= date("M jS, Y"); $time= date("g:ia"); mysql_query ("INSERT INTO $tablename (topic, comment, username, date, time) VALUES ('$topic','$comment','$username','$date','$time')");
Is there a more efficent way to record time to where I can combine date and time and just select the 10 most recent results?