MySql query from a php script

[Anon]

Having trouble using this query in a command line php script:

select INET_NTOA(ip_src) as Source, INET_NTOA(ip_dst) as Destination, sig_name as "Attack Signature", timestamp as Time FROM iphdr, event, signature WHERE INET_NTOA(ip_dst)="206.105.22.3" && event.cid=iphdr.cid && event.signature=signature.sig_id;

Works ok from mysql commnad line, but when I put it in a php script I get parse errors, nothing more descriptive about just what php doesn't like.

I've tried taken out the 'as' statements and even the addtional qualifiers '&&', still won't go.

Any help appreciated,
Robin

[Anon]

Is it all inside " quotes "?
if so, use single quotes(') inside the query

[Anon]

Ah, works great now, many thanks. Just need to add some formatting to the output!

Again, thanks.

-Robin