显示MySQL中特定行的数据

Question

I'm building a simple bug tracking tool. When you create a new project, all the info you fill in in the form, gets stored in the database.

When you create the new project you get redirected to a unique project page. On top of the page it shows the name of the project, but it's not the name of the project I just created, it always shows the name of the first project in the MySQL table.

How can I show the name of the project I just created?

With this query I retrieve the data from the database.

$query = "SELECT CONCAT(name) 
AS name FROM projects";
$result = @mysql_query ($query)

With this I show the project name, but it always shows the name of the first record in the table.

    <?php 
    if ($row = mysql_fetch_array ($result))
        echo '<h5>' . $row['name'] . '</h5>'; 
    ?>

It isn't yet SQL Injection prove and is far from complete... But I'm really struggling with this problem.

Answer 1

Try using ORDER BY.

$query = "SELECT CONCAT(name) 
AS name FROM projects ORDER BY id DESC";

This would show the most recent project (assuming you have an ID column).

However, a much better way is to have an ID variable on the page.

$query = "SELECT CONCAT(name) 
AS name FROM projects WHERE id=?";