[SOLVED] Query Help

[ballouta]

hello,

 

I have many rows inserted into a table in my DB, the ID is a primary key and it is set to auto increment, I have another column called 'arrange', (int).

 

I want to get the last 'arrange' value inserted in the table (when ID is order by ASC).

 

please help, Thank you

 

 

[jackpf]

You mean like this?

$sql = mysql_query("SELECT * FROM table ORDER BY id DESC LIMIT 1");
$fetch = mysql_fetch_array($sql);
$last_arrange = $fetch['arrange'];

[ballouta]

Thank you

[jackpf]

Jolly good.