PHP SQL subquery?

[Miko]

Hello,

 

I'm trying to make a query that select's the max date:

 

my query is like this:

 

SELECT MAX(scandate)  AS datum FROM STATUSDATA WHERE depot = '$pkdepot' AND pknr BETWEEN '$pknv' AND '$pknb'

 

this query isn't a problem, but I would like to echo the column depot also.

I know that I can do that with another query, but I want that it is done with 1 query.

 

Thanks

[trq]

SELECT MAX(scandate)  AS datum, depot FROM STATUSDATA WHERE depot = '$pkdepot' AND pknr BETWEEN '$pknv' AND '$pknb'

[Miko]

hi, thanks for the respons, but it doesn't work  ???

[kickstart]

Hi

 

Presuming you want the max date for each depot (would be meaningless otherwise):-

 

SELECT MAX(scandate)  AS datum, depot 
FROM STATUSDATA 
WHERE depot = '$pkdepot' AND pknr BETWEEN '$pknv' AND '$pknb'
GROUP BY depot

 

All the best

 

Keith

[luca200]

It looks to me like it's meaningless anyway, as far as 'depot' is in the WHERE condition...