- Where Developers Learn, Share, & Build Careers


My project has a user account, which has photos of each user that they have uploaded

Like to show a next and previous picture for each user, so when I go to the Friends list of pictures, I can navigate to the next uploaded users (obviously). I will be fine with these pictures next with the next / previous picture.

How would you write that kind of query for one / next photo?

My table structure is similar, it is not so. 

  If user does not have it then 'userphotos' (`photo_id` int (11) does not auto_interpret,` photo_ownerid` int (11) no, zero, `photo_right` integer (11 ) No tap, `photo_name` (100) no tap,` photo_ caption '(100) tap, `photo_imagegeta` is not long tap, album_id_t (11) faucet, primary (` photo_id`)) Engine = mysome default charset = latin1 AUTO_INCREMENT = 89;   
 Will I use something like this to choose from the  
 pre image  
  SELECT field1, from where Tablename WHERE id & lt; $ Currentid ORDER ID DESC limit 1   
 Next image  
  SELECT field1 to tablename ID; $ Currentid ORDER ID ASC limit1    
 
 
 What those questions should do for you . Although you should include the owner ID to limit the photos that will be browsed by the user's ownership.  
  Previous image   
  SELECT field1WERE id from Tablename   
  Next image   
  SELECT field1 to Tablename WHERE ID & Gt; $ CurrentId and photo_ownerid = $ ownerId ORDER ID ASC limit1   
 However, as the question has been indicated in the comment, every time you want to see the database, the next / previous picture example For, you can ask all photos at once, for example, use the Javascript library so that the photos can organize and navigate systematically.

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more