<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=651560616-12102006><FONT face=Arial size=2>I've create a small
interface in PHP that submits a ticket to RT using the
rt-mailgate.</FONT></SPAN></DIV>
<DIV><SPAN class=651560616-12102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=651560616-12102006><FONT face=Arial size=2>However, I've been
trying to pull data from the MySQL database so I don't have to constantly
create/manage user accounts in RT. This cusotmized interface pulls the basic
ticket info from the Tickets table fine. However, when I go to view the history
of the ticket it pulls random info from Attachments. </FONT></SPAN></DIV>
<DIV><SPAN class=651560616-12102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=651560616-12102006><FONT face=Arial size=2>I understand that it
is more an object-oriented thing from Perl's DBI-builder that allows RT to
customize how it pulls data, but how should I go about constructing a MySQL
query to pull all data on a particular ticket based on the Ticekts.id and
Tickets.EffectiveId?</FONT></SPAN></DIV></BODY></HTML>