[RESOLVED] Help Please. ORDER BY date? Code and Query Inside.

[Keyboard_Cowboy]

Hi. I am in need of some help.

I am making a forum for a project for my school, I have had a lot of bumps in the road but its just about finished, my last problem is this. When ever I create a new thread on the forum, it adds the new thread to the bottom of the page instead of adding it to the top, below is my queries

$select_forum_thread2 = "select * from `forum_threads` where `categorie_id` = '" .$_GET['categorie']. "' LIMIT ".$offset." , ".$rowsPerPage."";

And here is the function for added the new thread to the database.

<?php 
	if (isset($_POST['add'])) {
$code = $_POST['code'];	
$theicon = $_POST['posticon'];	
$title = invoer($_POST['title']);
$contents = invoer($_POST['contents']);
$ip = $_SERVER[REMOTE_ADDR];
$username = $memb->username;
$year = date('Y');
$month = date('M');
$day = date('d');
$date = $year. "-" .$month. "-" .$day;	

if ($contents == "" OR $code == "" OR $title == "") {
echo"Please fill in all the fields!<br>";$error=1;
}
if ($_POST['code'] != $_SESSION['image_random_value']) {
echo"Please fill in the right security code<br>";$error=1;
}
if ($error != 1) {

$reg_invoer = "INSERT INTO `forum_threads` (`categorie_id` , `owner` , `title` , `text` , `date` , `ip` , `icon`) VALUES ('$categorie_id' , '$username' , '$title' , '$contents' , '$date' , '$ip' , '$theicon');";
mysql_query($reg_invoer);
?>

I just don't know why I can't get it to display new threads at the top of the page, it always goes to the bottom, I've tried to use ORDER BY but I failed. If anyone can fix it or give me help I would be greatly thankful

[jorgepinho]

Hi!

Yes, the ORDER BY is the way to do it!

Have you tried ?

"SELECT .......   ORDER BY id DESC"

DESC makes it reverse order.

One note:

If you are saving a date on the DB, you can just use the NOW() function like this:

$reg_invoer = "INSERT INTO `forum_threads` (`categorie_id` , `owner` , `title` , `text` , `date` , `ip` , `icon`) 
VALUES ('$categorie_id' , '$username' , '$title' , '$contents' , NOW() , '$ip' , '$theicon')"; 

this way you can delete the code:

$year = date('Y');
$month = date('M');
$day = date('d');
$date = $year. "-" .$month. "-" .$day;  

but make sure that "date" field is a datetime type, not just date, because you will only be able to sort the posts by day (unless you use an id)

--
Jorge
Live chat voice help - letstalkabouthelp.wordpress.com

[Keyboard_Cowboy]

Thanks for the advice. It worked.

I noticed though that using datetime, it only saves date locally from my test server with a 24 hour clock instead of 12 hour clock, do you know how to create the 12 hour clock instead of it displaying the 24 hour clock?

[bradgrafelman]

Keyboard Cowboy wrote:

it only saves date locally from my test server with a 24 hour clock

That's (one of) the standard (and/or one of the most common) ways of storing times (12h timestamps are confusing without extra data which is then seemingly pointless when compared with 24h formats).

Your issue is with displaying the data, not with storing it. Instead, use MySQL's DATE_FORMAT() to retrieve the data in whichever form you please.

[Keyboard_Cowboy]

Oh wow, thank you. I did not know that. My issues are now completely 100% RESOLVED. I really do appreciate the time you two took to answer my questions. I still have 3 days left until I have to present this project to my class. I still have time to add more features to it. 🙂 Thanks again 😃