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 say row ent_nws_id=3. I didn't see any function like
> EXCEPT in the manual and I'm not sure if NOT is the right function to use
> because haven't been able to get it to work.
Don't you just want to add " AND ent_nws.ent_nws_id <> 3" to the end
of your query?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
