Development Discussion Board

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 ...

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 ...

Hmm has karma been reset? Mine seems to be at 0 now

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 ...

Thanks for the idea but it doesn't work, it simply returns 1 instead of 0

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 ...

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 ...

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'

I'm from England as well (currently in Scotland) and can't spell to save myself half the time.

psoTFX wrote:\\1

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 :X
Oh well, just a reminder who the PHP king around here is I suppose