Hello.
I wrote this small bulleten board script but I want the order to go from newset on top and oldest on bottom but it goes the other way and I try to order it from ID but I am not sure how to make the ID go up by one when the person Posts. I can show you my source script to see it any one can help me.
<body bgcolor="black">
<table width="500" style="border:double teal 20px" cellpadding="3" cellspacing="2" border="2" bgcolor="green" align="center">
<?
$connection = @mysql_connect("localhost", "....", "......") or die(mysql_error());
$comments = "SELECT * FROM post";
$makelist = mysql_db_query("bullit", $comments);
if ($makelist){
$rows= mysql_num_rows($makelist);
for ($msg=0; $msg < $rows; $msg++){
$person= MYSQL_RESULT ($makelist, $msg, "name");
$ID= MYSQL_RESULT ($makelist, $msg, "id");
$Field= MYSQL_RESULT ($makelist, $msg, "comment");
echo "<tr><td colspan='2'>$person</td></tr><tr>
<td width=10%>$ID</td><td>$Field</td></tr><tr>
<td colspan='2' height='20'bgcolor='teal'></td></tr> ";
};
};
?>
</table>
<center>
<form>
<Input type="text" name="name" size="30">
<br>
<textarea name="comment" cols="40" rows="10"></textarea>
<input type="submit" value="Post_Comment" OnClick="document.location.reload()">
</form>
</center>
<?
if($_GET[name] != ""){
$query = "INSERT INTO post VALUES ( '$GET[id]', '$GET[comment]', '$_GET[name]')";
$result = @mysql_db_query ("bullit", $query) or die(mysql_error());
};
?>
