| Author |
 Topic  |
|
Arne2
New Member
Denmark
51 Posts |
 Posted - 22 March 2003 : 05:19:17
|
| I only get the built in error messages I referred to in my post above: "There Was A Problem With Your Details" and the other one. |
 |
|
|
Arne2
New Member
Denmark
51 Posts |
Posted - 22 March 2003 : 05:24:06
|
| Where is it that you use total_posts after you have run the sql? I can not spot where that variable is used afterwards. In my PHP script you can clearly see it being used. |
Edited by - Arne2 on 22 March 2003 05:26:22 |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 22 March 2003 : 05:28:46
|
Ummm well I have no idea, the message There are no replies to this topic! should only be shown if the query does not bring any records back.
It uses GetRows so maybe there is a problem there with mySQL, but it works with the rest of the forum so I doubt it.
Try adding a -1 as shown below (in pop_posted.asp), thats something the forum code does that I did not.
if Not rsPosted.EOF then arrPosted = rsPosted.GetRows(-1)
I have no idea if that will help but its worth a try anyway. |
|
|
|
Arne2
New Member
Denmark
51 Posts |
Posted - 22 March 2003 : 05:34:37
|
| No there was no change using the -1, sorry. |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 22 March 2003 : 05:42:49
|
quote:
Originally posted by Arne2
Where is it that you use total_posts after you have run the sql? I can not spot where that variable is used afterwards. In my PHP script you can clearly see it being used.
Its not used anywhere really, I only had it in when I was looking at the SQL in Query Analyzer, otherwise you don't have a column name. |
Edited by - Hamlin on 22 March 2003 05:43:28 |
|
|
|
Arne2
New Member
Denmark
51 Posts |
Posted - 22 March 2003 : 05:47:54
|
| Well, I spent 3 whole days on it before I gave up LOL, and did not get anywhere. I changed the sql to not have the total_post in it and put in member_id in it's place, without a count, and it worked fine, but now of course just showing the author name and his member number in the second row. |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 22 March 2003 : 05:49:51
|
quote:
Originally posted by Arne2
Well, I spent 3 whole days on it before I gave up LOL, and did not get anywhere. I changed the sql to not have the total_post in it and put in member_id in it's place, without a count, and it worked fine, but now of course just showing the author name and his member number in the second row.
So it was is a problem with the query  |
Edited by - Hamlin on 22 March 2003 05:50:47 |
|
|
|
Arne2
New Member
Denmark
51 Posts |
Posted - 22 March 2003 : 05:54:03
|
Of course I had to change the error check (I stopped it) when I did that - I forgot to mention this  |
|
|
|
Arne2
New Member
Denmark
51 Posts |
Posted - 22 March 2003 : 12:10:40
|
Suggestion:
While I was at it with my PHP version, I also added the date ( MAX(R.R_DATE) AS MAX_DATE) so that I get it sorted by max_date desc
You can see it in one of the open forums here:
Link
I don't want the other links there, so I left them out.
Regards
Arne |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 22 March 2003 : 12:49:27
|
Thats not a bad idea, glad to see the your PHP version works at least  |
|
|
|
Topic |
|
Topic Locked
