close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Need to display database field by DESC but it's not working

Thread began 12/27/2009 7:18 pm by ijk76319396 | Last modified 1/11/2010 11:55 am by ijk76319396 | 2498 views | 8 replies

ijk76319396

I will let you know exactly how the database is and give you a quick example and see if that helps. A user is looking at a comic by "MEMBER-1" they are looking specifically at "PAGE#1". They click on a 5 to rate the comic.The fields that go into the database are ARTIST="MEMBER-1" PAGE="PAGE#1" and rating="5" as well as a hidden field capturing the users IP and a auto-increment field that gives the message a unique numerical ID. So the fields that matter are the first three as I use the rating with the average rating function which is working fine. The ARTIST field is used to sort by group by specific artist/comic also works fine. Now the problem is that the page being displayed is always going to be PAGE#1... when the user goes to page two and rates a 3 for example the following is correctly being entered into the database ARTIST="MEMBER-1" PAGE="PAGE#2" and rating="3"now on the indexalt.php page I posted above I would like instead of "PAGE#1" being displayed for it to display "PAGE#2" of the same comic, with the rating and group still working the way it does. Hope this isn't too confusing but that's the best I can do to describe what I am attempting.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...