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
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
-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
: [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
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
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
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
7 matches
Mail list logo