Help w/Query

2002-04-10 Thread Mike
Hi, I've been trying to find some info on running a select statement that would return a few rows and leave out one specific row. Here is my select statement: $result = mysql_query(SELECT ent_nws_id,img_path,substring_index(ent_body, \.\ ,1) AS ent_body FROM stns,images INNER JOIN ent_nws

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
-1473 --- -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: 10 April 2002 22:24 To: mysql list Subject: Help w/Query Hi, I've been trying to find some info on running a select statement that would return a few rows

Plz help w/ query

2002-01-31 Thread Anthony Rodriguez
The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. ?php $connection=mysql_connect(localhost,wagner,xxx) or die (No connection!);

RE: Plz help w/ query

2002-01-31 Thread Rick Emery
: Plz help w/ query The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. ?php $connection=mysql_connect(localhost,wagner,xxx) or die (No connection!); $db

Re: Plz help w/ query

2002-01-31 Thread DL Neil
7:32 AM To: [EMAIL PROTECTED] Subject: Plz help w/ query The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. ?php $connection=mysql_connect(localhost,wagner