Here was what I ended up with. It appears to work but I need to add data with a few different months timestamp to verify.
// These are my start and end data filter
$date1="02/01/2004";
$date2="02/29/2004";
// Now we convert the dates
$time1=strtotime($date1);
$time2=strtotime($date2);
// select statement from HELL!
$result = mysql($database, "select * from ezu_files a, ezu_uploads b, ezu_uploadinfos c WHERE b.id = a.upload AND a.type='i-world/i-vrml' AND b.id = c.upload AND c.name='Description' AND b.uploaded between '$time1' and '$time2'");
I am not sure how efficient the select statement is but I don't know of a better way. That is another post I guess.
Cheers,
Ed
