[PHP] Grr SQL syntax error silghtly OT

2002-07-09 Thread JJ Harrison
Sorry :} I get a SQL syntax error at line two of the query: $query = select 2count(*) as tececo_stats.views, meta_data.title from meta_data, tececo_stats where meta_data.id = tececo_stats.id; I have stared at this 'till i felt dizzy. can someone tell me what I am doing wrong so that I can

RE: [PHP] Grr SQL syntax error silghtly OT

2002-07-09 Thread Brian McGarvie
2count(*)? don't look right -Original Message- From: JJ Harrison [mailto:[EMAIL PROTECTED]] Sent: 09 July 2002 9:10 AM To: [EMAIL PROTECTED] Subject: [PHP] Grr SQL syntax error silghtly OT Sorry :} I get a SQL syntax error at line two of the query: $query = select 2count

RE: [PHP] Grr SQL syntax error silghtly OT

2002-07-09 Thread joakim . andersson
-Original Message- From: JJ Harrison [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 10:10 AM To: [EMAIL PROTECTED] Subject: [PHP] Grr SQL syntax error silghtly OT Sorry :} I get a SQL syntax error at line two of the query: $query = select 2count(*) as tececo_stats.views

Re: [PHP] Grr SQL syntax error silghtly OT

2002-07-09 Thread JJ Harrison
: [EMAIL PROTECTED] Subject: [PHP] Grr SQL syntax error silghtly OT Sorry :} I get a SQL syntax error at line two of the query: $query = select 2count(*) as tececo_stats.views, meta_data.title from meta_data, tececo_stats where meta_data.id = tececo_stats.id; I hav

RE: [PHP] Grr SQL syntax error silghtly OT

2002-07-09 Thread joakim . andersson
PROTECTED]] Sent: Tuesday, July 09, 2002 11:07 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Grr SQL syntax error silghtly OT table structure for tececo stats(Stores information about the visitors to my site.visited is either 0 or 1 depending on whether or not the stats cookie has been set

RE: [PHP] Grr SQL syntax error silghtly OT

2002-07-09 Thread joakim . andersson
Forgot. You have to change $row['tececo_stats.views'] to $row['num_hits'] /J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 11:15 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] Grr SQL syntax error silghtly OT I would try

Re: [PHP] Grr SQL syntax error silghtly OT

2002-07-09 Thread JJ Harrison
d GROUP BY tececo_stats.page_id ORDER BY num_hits DESC /Joakim -Original Message- From: JJ Harrison [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 11:07 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Grr SQL syntax error silghtly OT table structure for tececo stats(Stores informati