RE: Help w/Query

2002-04-10 Thread Peter Lovatt
Hi Change your WHERE statement to WHERE stns.stns_id=1 AND table.ent_nws_id <> "3" ' HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-2

Re: Help w/Query

2002-04-10 Thread Keith C. Ivey
On 10 Apr 2002, at 17:23, Mike wrote: > $result = mysql_query("SELECT > ent_nws_id,img_path,substring_index(ent_body, \".\" ,1) AS ent_body FROM > stns,images INNER JOIN ent_nws ON stns.stns_id=ent_nws.stns_id and > images.img_id=ent_nws.img_id WHERE stns.stns_id=1",$db); > > I'd like to lea