simple array sorting

johnm1958

I am a complete newbie and can't figure out how to sort a simple database.

I have a db called 'garage' with a table called 'cars' that has the fields id,make,model. The code below allows me to insert data but I wish to then sort it by id.

<html><body><?php


$user="root";
$conn=mysql_connect("localhost","root","")or die("err:conn");

$self=$_SERVER['PHP_SELF'];
$id=$_POST['id'];
$make=$_POST['make'];
$model=$_POST['model'];
?>
<form action="<?php echo($self);?>" method="post">
ID:<input type ="int" name="id">
make: <input type="text" name ="make">
model:<input type="text" name="model">
<input type="submit" value ="Submit"></form> 
<?php 
$rs=mysql_select_db("garage",$conn)or die("err:db");
$sql="insert into cars (id,make,model)values($id,\"$make\",\"$model\")";
$rs=mysql_query($sql,$conn);
if($rs){echo("Record added:$id $make $model");}

else die("Record not added");
$arr=array($id,$make,$model);
rsort ($arr);

?>
</body></html>

you will see my attempt at sorting in the two lines of code starting $arr. That doesn't work. How do I do it please?

ClarkF1

Well at the moment it's only sorting the elements that have been inputted in the form and there is only element in the array.

Are you trying to sort the mySQL table???

If so this is normally done when outputting data from a table.

johnm1958

yes I want to sort the whole table. I am just doing this exercise to learn but my aim is to create a high score database for a flash game. i will want to return the highest scores to the game but each time the table is updated, delete all scores more than 7 days old.
Thus i need to learn how to sort an array by the timestamp field and delete old entries.