Search found 288 matches
- Wed Jan 28, 2004 10:58 pm
- Forum: Chit Chat
- Topic: Finding unused integer values with MySQL
- Replies: 13
- Views: 11336
Re: Finding unused integer values with MySQL
Actually someone has suggested a query which seems to be working perfectly over at the Dev Shed forums: Click here to view the solution The reason is that I really want to be able to replace rows in a table. A shoutbox I think is probably a bad example but it wasn't an important table so I decided t...
- Wed Jan 28, 2004 1:38 pm
- Forum: Chit Chat
- Topic: Finding unused integer values with MySQL
- Replies: 13
- Views: 11336
Re: Finding unused integer values with MySQL
Roberdin that query doesn't work, it's much the same as the one I posted earlier and the problem seems to be that the + 1 in the WHERE part is being ignored entirely. The query returns the same value regardless of anything, in your case '2'. The query should theoretically look at each row in the sho...
- Tue Jan 27, 2004 12:58 pm
- Forum: [3.0/Olympus] Discussion
- Topic: Karma Level
- Replies: 18
- Views: 15140
Re: Karma Level
Hmm has karma been reset? Mine seems to be at 0 now
- Tue Jan 27, 2004 12:56 pm
- Forum: Chit Chat
- Topic: Finding unused integer values with MySQL
- Replies: 13
- Views: 11336
Re: Finding unused integer values with MySQL
Thanks for the idea sparkster but that's not it either, in the example info I gave in the first post that query would return 7 instead of 2. Thing is that I'm certain that the query I posted at the start should work (theoretically :)) but it doesn't which suggest that MySQL isn't doing anything with...
- Mon Jan 26, 2004 7:01 pm
- Forum: Chit Chat
- Topic: Finding unused integer values with MySQL
- Replies: 13
- Views: 11336
Re: Finding unused integer values with MySQL
Thanks for the idea but it doesn't work, it simply returns 1 instead of 0
- Mon Jan 26, 2004 5:02 pm
- Forum: Chit Chat
- Topic: Finding unused integer values with MySQL
- Replies: 13
- Views: 11336
Finding unused integer values with MySQL
Okay, I know I'm all problems lately but here it goes with another problem that is probably simple but I can't find the answer to myself: Quite simply I want a MySQL query than can search a column of a table and return the earliest unused integer. For example, I have five rows in a table as follows:...
- Mon Jan 26, 2004 2:14 pm
- Forum: [3.0/Olympus] Discussion
- Topic: Portal Status?
- Replies: 10
- Views: 13281
Re: Portal Status?
Yeah, I expect the portal will use much the same technology as phpBB 2.2 and it will likely be developed with integrating with phpBB forums in mind. Since the template system is receiving quite a big overhaul with caching and the various nifty features in it it would be unrealistic to do a whole lot...
- Mon Jan 26, 2004 2:08 pm
- Forum: [3.0/Olympus] Discussion
- Topic: Karma Level
- Replies: 18
- Views: 15140
Re: Karma Level
I'm not sure what the exact formula is but I expect that it takes into account the same person rating all your posts bad by devaluing them and only taking the bad votes into account if several people are voting your posts as 'bad'
- Mon Jan 26, 2004 2:04 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: Invisionfeatures: Most active in..., calender, birthdays
- Replies: 79
- Views: 57918
Re: Invisionfeatures: Most active in..., calender, birthdays
I'm from England as well (currently in Scotland) and can't spell to save myself half the time.
- Sun Jan 25, 2004 9:47 pm
- Forum: Chit Chat
- Topic: Tags within tags and preg_replace
- Replies: 7
- Views: 6514
Re: Tags within tags and preg_replace
Hey thanks psoTFX! I must admit to spend hours trying to figure it out only to have you point out I missed a single backslash is a tag frustrating :XpsoTFX wrote:\\1
Oh well, just a reminder who the PHP king around here is I suppose