SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 03-12-2008, 01:51 PM
plxkarl plxkarl is offline
Junior Member
 
Join Date: Mar 2008
Location: Toronto
Posts: 1
plxkarl is on a distinguished road
Default ANY dialect question:

Newly uploaded photos


Well, first of all - very interesting website... Hopefully you guyz get lots of users so everybody can help out eachother... Back to my topic.

I have a photo gallery where user can upload photos. I'm using ImageUploader therefore datestamps for each photo uploaded vary between 20sec-2min depending on users connection. User can upload up to 50 photos at once therefore the first photo that gets uploaded has a date stamp of eg. Jan 01 2008 12:00:00 and the last photo uploaded in that session will have a date stamp of Jan 01 2008 12:10:00 which is 10 mins after the first photo.

My question is how do I query the database to get newly added photos. I was thinking of grouping photos that are 1hr or more apart from eachother and generating an average datestamp for those photos (or just use the last photos datestamp). How would I go about doing that using one or more queries in MySQL and maybe with the help of PHP too.

Thank You,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Be the first to answer this question! Click on the 'Post Reply' button below.
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 04:55 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8