如何排序列id和列名

Question

I've uploaded the pdf document to the mysql database. but I do not pay attention when uploading data sorting techniques in alphabetical on the column name. then I want to sort the data in alphabetical pdf file for indexing.

$sql="SELECT * FROM upload ORDER BY name ASC";

My problem is, how to be able to sort the records in the column names in alphabetical order alphabet and id columns can also be ordered starting with number 1? How to do it?

it is my source code :

<tr>
<td>No. </td>
<td>File Name</td>
<td>File Type</td>
<td>File Size(KB)</td>
<td>View</td>
</tr>
<?php
$sql="SELECT * FROM upload ORDER BY name ASC";

$result_set=mysql_query($sql);
$nomor=1;
while($row=mysql_fetch_array($result_set))
$nomor++;
{
    ?>
    <tr>

    <td><?php echo $row['name'] ?></td>
    <td><?php echo $row['type'] ?></td>
    <td><?php echo $row['size'] ?></td>
    <td><a href="fileupload/<?php echo $row['name']?>" target="_blank">view file</a></td>
    </tr>
    <?php
}

?>

Answer 1

Not really sure I understand what you ask but if you want to order on name and or id simply do this

$sql="SELECT * FROM upload ORDER BY name ASC, id ASC";

It will start by ordering on name then on Id. You will see a difference only if you have duplicate names.

Also you don't care about sorting when you insert data, as you don't care about indexing ordering. You index a field to be able to sort faster.

If you want to sort on name and on id then you have to use a variable

$sort = $_GET['sort'] ?: 'name'; // défaut sorting on name

$query = "SELECT * FROM table WHERE ... ORDER BY $sort ASC"; //careful about SQL injection, protect $sort value with the escape method provided by your driver.

You have to give all information for sorting in GET parameters. Look into phpmyadmin URL you will see them.