On Sat, Mar 24, 2001 at 06:40:09AM +0100, Martin Skj?ldebrand wrote:
> I've tried:
>
> "SELECT ticket.t_id, t_client, t_summary, e_assignedto, e_status FROM
> ticket, events WHERE e_status = 'REGISTERED' AND e_assignedto = 'Not
> Assigned' AND ticket.t_id = events.t_id";
>
> This gives me ALL hits on this string. Including tickets that have had the
> desired status but is now assigned to someone.
>
> Any suggestions? I'm using MySQL as a database.
> Apologies if this is an unappropriate list - and grateful for pointers to
> the correct forum.
I think this is an appropriate list, but since you are using Mysql, you
might want to try asking @ [EMAIL PROTECTED] I can try to help,
but unfortunately, I will have to see the table structure so I can
actually understand what you are trying to accomplish.
--
Jason Stechschulte
[EMAIL PROTECTED]
--
Tactical? TACTICAL!?!? Hey, buddy, we went from kilotons to megatons
several minutes ago. We don't need no stinkin' tactical nukes.
(By the way, do you have change for 10 million people?) --lwall
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]