rhiaro Posted March 8, 2009 Share Posted March 8, 2009 I have images stored in a mediumblob in a database (I've read many of the arguements for and (mostly) against this kind of storage, let's just assume it's necessary for now..). I think I know roughly what I need to display these images how I want... I'm just having trouble writing the code as I'm still pretty much a beginner and having trouble wrapping my head around exactly what i need... Was easier to just draw, so I hope the attached image explains what I'm trying to achieve. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/148457-retrieving-images-from-blob-storage/ Share on other sites More sharing options...
RussellReal Posted March 8, 2009 Share Posted March 8, 2009 sort by id and and do LIMIT 1,1 LIMIT 2,1 LIMIT 3,1 the mysql query would look similar to: SELECT `image_blob` FROM `image_table` ORDER BY `image_id` ASC LIMIT 1,1 Quote Link to comment https://forums.phpfreaks.com/topic/148457-retrieving-images-from-blob-storage/#findComment-779466 Share on other sites More sharing options...
Mchl Posted March 8, 2009 Share Posted March 8, 2009 And your question is? Quote Link to comment https://forums.phpfreaks.com/topic/148457-retrieving-images-from-blob-storage/#findComment-779467 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.