auto increment

innerc

Here's my deal.... And i haven't really even gotten started... so it's easy to change my game plan.

Using PHP and MySQL...
I want to have a form where people can fill it out when they need help... kind of like a support ticket system.
They fill out a support request... it saves it in a database... I reply to it and it saves it in the database. and so on...

I started by making a column for the THREAD.... and then one for each TICKET entry under that thread number.

The first person uses the support ticket system... it gives the thread the number 555 (let's pretend that's where we start it )

Another person starts a completely different thread... it's given the number 556.... this is simple auto increment.

Well..... the way the actual support ticket number would look is:

555-001
555-002 .. for each ticket in the thread.

the second thread would be:

556-001
556-002

The first number (before the dash) is the auto incremented THREAD column...
But how can i get the second number ( TICKET ) to auto increment when people reply to each thread.

I thought that this would/could happen on the REPLY page.

SO... remember that I have two columns that need to be incremented at different times... a THREAD column... and TICKET column.

How can I get PHP to look at the MySQL database and see where the last TICKET number is within the current THREAD... and add one number and give that as the new TICKET number?

Tomz

Hi,

If I were you I wouldn't make the threat number auto increment.
Autoincrement increments at each row in your database. I assume that every threat and reply go into a seperate row.

Just make a column for threatnumber and replynumber.

Whenever someone creates a new threat (ticket) you tell your script to make a new row in your database and fill in the threatnumber which is the last one +1.

Same for replies but then in the column for the replynumber.

Displaying all posts in threat nr 555 you would use something like

SELECT * FROM tablename WHERE threat=555

Displaying replynr 1 in threat 555 would be something like

SELECT * FROM tablename WHERE threat=555 and reply=1

innerc

OK. Sounds kinda like what i have in mind.... but....

If i have 3 rows of data for THREAD number 1, how do I get my script to SEE how many rows there are and ADD 1 to it.... ( to make 4 ) ?

The_Chancer

Look at the MAX( ) and group by commands for the SQL...

SELECT MAX(reply) as reply FROM `threads` WHERE threadid='".$i."' GROUP BY threadid

Something along those lines...

innerc

But I'm not good with this yet... not outside my little box of PHP that i've learned... So I'm not completely sure how to use this.
I'll have to experiment with it...

Thanks Chancer for pointing me in the right direction. At least I know what I'm looking for now... =)

But in the mean time... if there's someone out there willing to help me know more about this .... I'd appreciate it.
( by that i mean... walk me through how to use this code )