I have a script I wrote for my forums I am making, which are coming out nicly, I took David's advice and read my PHP book in further depth. But it doesn't seem to mention how to order information strait for the database as you would want to in a forum.
I have something like:
<?php
$topic = mysql_query("SELECT `name`, `desc`, `poster`, `id` FROM `topics` WHERE `id` = '$_GET[tid]' ORDER BY `id`");
?>(Much more to the code that's just a segment)
And what it does is since the only 2 topics I have made are 1 and 2 to test with 2 apears on top of number 1 in the topic view. I know it's the ORDER BY `id` that's screwing it up but I cannot figure out how to get it to order from least to greatest, because not it's going from greatest to least desending.
All help is appresiated!
ORDER BY has another clause called "ASC" and "DESC" which take whatever column you specify (like "id") and alphabetically order it.
<?php
mysql_query('SELECT * FROM `table` ORDER BY `id` ASC');
?>Also, don't use double quotes (") when working with strings as it takes longer. Second, make sure to sanitize your sql (mysql_real_escape_string) or you WILL get hacked! Third, don't set mysql_query() to a string - just do something like:
<?php
$query = 'SELECT `name`, `desc`, `poster`, `id` FROM `topics` WHERE `id` = \''. mysql_real_escape_string($_GET['tid']). '\' ORDER BY `id` ASC';
//If there is a problem
if(!mysql_query($query)) { die 'MySQL Error:'. mysql_error(); }
//on with the code
?>
