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 leave out

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.