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] 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 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? 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
Archived
This topic is now archived and is closed to further replies.