Click here to Skip to main content
15,914,222 members
Home / Discussions / Web Development
   

Web Development

 
GeneralASP file download Pin
scrasch6-Jan-03 14:50
scrasch6-Jan-03 14:50 
GeneralRe: ASP file download Pin
Jason Henderson7-Jan-03 3:10
Jason Henderson7-Jan-03 3:10 
QuestionAny opinions on the best way to transfer binary data with SOAP? Pin
moredip6-Jan-03 12:56
moredip6-Jan-03 12:56 
AnswerRe: Any opinions on the best way to transfer binary data with SOAP? Pin
Paul Ingles7-Jan-03 1:19
Paul Ingles7-Jan-03 1:19 
GeneralRe: Any opinions on the best way to transfer binary data with SOAP? Pin
moredip7-Jan-03 5:16
moredip7-Jan-03 5:16 
GeneralASP and Outlook meetings Pin
mutumbo6-Jan-03 5:00
mutumbo6-Jan-03 5:00 
GeneralRe: ASP and Outlook meetings Pin
Jeremy Oldham7-Jan-03 1:27
Jeremy Oldham7-Jan-03 1:27 
GeneralCP Forums Pin
Jon Newman5-Jan-03 9:59
Jon Newman5-Jan-03 9:59 
Before I download the ASP version of the CP Forums from the article. I was wondering if any PHP/MYSQL buffs are around to help me.

I have set up my own forums based on the php version of the CP forums, however apart from the layout, I have more or less re-written the PHP behind it to slot in with my members access scripts. However, The only annoying thing is that when a post is trying to be accessed the URL variable is

&select=912

Where 912 is the 'ID' field in the MySQL database for the forums, i've kept the current structure because there are too many posts in the database to change the structure too much. The problem is that if the post is an old one, the script does not know how to goto that post because the way it navigates through the posts is by having a &start=30 URL variable that will shift the start point of the MySQL query to 20 posts back. And the post ID's are not per-forum, but are the same for every post. i.e. Post 193 could be in the lounge, post 192 could be in the Suggestions forum and 134 could be in Help forum. Thus a simple total count minus the target post ID would not work.

My question is this, is there a way for me to find the position of a certain post in a query such as:

SELECT * FROM posts WHERE(ID = '193' AND forumID = '1')

Thus I could do a total minus the post ID to get a distance from the latest post in that forum to the target post.

I realise I could just have a "LIMIT 193,20" on the end of the query which would start the results at the target post, however I wish to navigate to and from that post much like CP does.

If anyone can understand what I mean and can help me, please do. Thank you, I think.





We brought out this new and very similar version of our expensive software because the old version was......old....It's a good enough excuse for Microsoft so its fine for us.



GeneralRe: CP Forums Pin
David Wulff5-Jan-03 10:36
David Wulff5-Jan-03 10:36 
Generalmeta tag search Pin
Sarvesvara (BVKS) Dasa4-Jan-03 21:42
Sarvesvara (BVKS) Dasa4-Jan-03 21:42 
GeneralCookie security Pin
alex.barylski4-Jan-03 2:01
alex.barylski4-Jan-03 2:01 
GeneralRe: Cookie security Pin
Paul Riley4-Jan-03 4:13
Paul Riley4-Jan-03 4:13 
GeneralRe: Cookie security Pin
alex.barylski4-Jan-03 11:19
alex.barylski4-Jan-03 11:19 
GeneralRe: Cookie security Pin
Paul Riley4-Jan-03 11:52
Paul Riley4-Jan-03 11:52 
GeneralRe: Cookie security Pin
Philip Patrick4-Jan-03 6:33
professionalPhilip Patrick4-Jan-03 6:33 
GeneralRe: Cookie security Pin
alex.barylski4-Jan-03 11:22
alex.barylski4-Jan-03 11:22 
GeneralUnique Solution Pin
Anonymous3-Jan-03 19:34
Anonymous3-Jan-03 19:34 
GeneralRe: Unique Solution Pin
Jason Henderson6-Jan-03 11:48
Jason Henderson6-Jan-03 11:48 
GeneralRe: Unique Solution Pin
Robby7-Jan-03 3:06
Robby7-Jan-03 3:06 
GeneralRe: Unique Solution Pin
Jason Henderson7-Jan-03 3:08
Jason Henderson7-Jan-03 3:08 
Generalrandom trappable errors Pin
Max Santos3-Jan-03 8:53
Max Santos3-Jan-03 8:53 
GeneralImage From asp Pin
Ghasrfakhri3-Jan-03 7:14
Ghasrfakhri3-Jan-03 7:14 
GeneralRe: Image From asp Pin
Philip Patrick3-Jan-03 22:45
professionalPhilip Patrick3-Jan-03 22:45 
GeneralRe: Image From asp Pin
Ghasrfakhri4-Jan-03 7:07
Ghasrfakhri4-Jan-03 7:07 
GeneralRe: Image From asp Pin
Philip Patrick4-Jan-03 8:53
professionalPhilip Patrick4-Jan-03 8:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.