mostly an (my)sql question.

[John <strgout () unixjunkie com>]

i've just started learning sql, and was wondering if
someone could give me a hand. I'm using per-dbi for
queries. 

at the moment. this is what my sql statement looks like.

SELECT event.cid,inet_ntoa(ip_src),inet_ntoa(ip_dst)
                        FROM event,iphdr
                        WHERE event.cid > 0
                        AND iphdr.cid = event.cid
                        LIMIT 500 

That much works fine. it prints events 1-500 However i 
can't seem to figure out how to link the signature table 
into this. I've tried many (bad :) ) things, and the end
result is a query that never ends most of the time or
even.cid goes from 1,6,10,etc,etc

So lets say i also want to print the priority of the
event, how would i add that?


-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users