RE: Help w/Query

2002-04-10 Thread Peter Lovatt
PROTECTED] tel. 0121-242-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 in

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

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: Plz help w/ query

2002-01-31 Thread DL Neil
o:[EMAIL PROTECTED]] > Sent: Thursday, January 31, 2002 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

RE: Plz help w/ query

2002-01-31 Thread Rick Emery
bject: 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. Thanks! Anthony F. Rodriguez ([EMAIL PROT

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. Thanks! Anthony F. Rodriguez ([EMAIL PROTECTED]) ---