table? last_response or whatever. Then you have everything you
need right in 1 table and just have to UPDATE the last_response when a
response is made.
Hope that helps.
Matt
- Original Message -
From: "brfg3 at yahoo"
Sent: Thursday, November 27, 2003 1:00 PM
Subject: list, order
MySQL version: 3.23.49
OS: Debian3
Scripting Language: PHP
I'm working on a trouble ticket system. There are several tables involved, but for
this query only two tables are involved: tickets and comments. They are related by the
ticketnumber field. This client cannot afford a high end database,