SELECT SQL Query

[SVC]

Hi,

 

I have an SQL query which selects the last id number in the table and retuns the result to be displayed.

 

I now need to go one stage further and -1 off of the number and the display that.

 

What do i need to include in my SELECT to get the last id number -1 ?

 

Thanks

 

Stephen

[Barand]

SELECT MAX(id) - 1 as maxIdLessOne FROM tablename

[SVC]

hi,

 

i have just tried that and cant get it to work, this is my SELECT that works for the first one, i also have other information being collected from other tables in the same statement.

 

"SELECT * FROM ((properties LEFT JOIN regions ON regions.region_id=properties.region_id) LEFT JOIN countries ON countries.country_id=properties.country_id) LEFT JOIN clients ON clients.client_id=properties.owner_id WHERE status=1 AND approved=1 AND (expiry_date='0000-00-00' OR expiry_date>='$today') ORDER BY property_id DESC LIMIT 1"