Conversation Table

[sladmin]

Hi,

I have a really big problem at the mo and I cannot continue until I sort it out.

I have a table that stores ticket data with a ticket ID and another table that has a ticketID column which stores the ticket conversation. Problem is when I create a repeat region It's repeating the same conversation row and not continuing to the next row in the table.

You see when somebody creates a ticket it creates a row in the conversation table that stores the ticketID along with a message, who updates the ticket last and the replier. When I reply to a ticket it creates another row with THE SAME TicketID but a different ConvoID. Problem is when I create a repeat region to show the conversation that is filtered via the TicketID it repeats the same record because it has the same ticket ID.

I know this is kind of confusing but I have posted two image of PHPMyAdmin so that you can get the jist of it.

Would be greatful if somebody could help me out in either getting the Recordset to LOOP or if somebody has a better idea on how to design my database. I thought maybe I could use a 'Joining' table that house the TicketID and Convo ID but maybe it would do the same as before?

Sorry for the complexity and hope somebody can help me.

Thanks In Advance,

http://silverlinewebdesign.co.uk/images/ticket.gif (http://silverlinewebdesign.co.uk/images/ticket.gif)

http://silverlinewebdesign.co.uk/images/conversation.gif (http://silverlinewebdesign.co.uk/images/conversation.gif)

[sladmin]

Just an update - got it sorted now some of the code went stupid and i decided to recode the repeat region which sorted it. As a follow on does anyone know how to allow line breaks in the code?

Cheers,