Porting SQL from frontpage/MS-Access

[greghilton]

Hi,

I'm trying to get the following to work in PHP that used to work in Frontpage/MS-Access:

Number one:
Counts the number of database entries that were entered on the last updated date:

select count(*) from master_list where date_added = ( select max(date_added) from master_list)

Number two:

Displays the date of the last entry:

select max(date_added) from master_list where date_added = ( select max(date_added) from master_list)

I've been trying to crack this for the past week with no success!

cheers,

greg

[steved]

Are you still using MS Access, or have you moved to a different database?

[greghilton]

Ah sorry about not making that clear, I've moved to mySQL.

cheers,

greg

[Anon]

I believe that MySQL does not support subqueries.

Have a look at http://www.mysql.com/development/todo.html

[greghilton]

So if mySQL doesn't support sub-queries, could anyone suggest how to do the SQL I need to do?

This is the last thing remaining in moving off Frontpage/Access!

cheers,

greg

[steved]

Looks like you'll need to do two different queries. The first to get your max date

select max(date_added) from master_list

and then use the results of that to do the second query

select count(*) from master_list where date_added = themaxdateijustgot