ta.id = tececo_stats.page_id
> 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]
> > Subjec
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 sy
[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 information about the
> visitors to my
> site.visited is either 0 or 1 depending on whether or
u_need_to_group_by
>
> It's really difficult to answer your questions without the table designs,
> the error message and what you expect this query to do. And, it's not
> slightly OT. It's totally OT. :-)
>
> Regards
> Joakim Andersson
>
>
> > -Original Mes
rds
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
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
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 lea
7 matches
Mail list logo
