[rt-users] MySQL Query from PHP

Patrick Humpal phumpal at execinc.com
Thu Oct 12 12:10:23 EDT 2006


I've create a small interface in PHP that submits a ticket to RT using
the rt-mailgate.
 
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. 
 
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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061012/c7771fbe/attachment.htm>


More information about the rt-users mailing list