Jack jacklistm...@gmail.com wrote:
Hello All,
I have this string defined for my query and it shows the different
types of
categories fine, but when I change a.categoryid = c.categoryid to
a.categoryid = 1 which is only one of the categories
It shows me the same record twice.
$query =
On 06/07/2012 09:37 AM, Jack wrote:
$query = select a.startdate, a.articleid, c.name, a.title, a.intro,
a.datecreated from articles as a, categories as c where (a.startdate = -1 or
a.startdate= {$now}) and (a.enddate = -1 or a.enddate= {$now}) and
a.categoryid = c.categoryid order by a.startdate
Thanks Jim, worked like a charm.
-Original Message-
From: Jim Lucas [mailto:li...@cmsws.com]
Sent: Thursday, June 07, 2012 4:08 PM
To: Jack
Cc: PHP
Subject: Re: [PHP] help with query
On 06/07/2012 09:37 AM, Jack wrote:
$query = select a.startdate, a.articleid, c.name, a.title
$number=mysql_num_rows(mysql_query(SELECT DISTINCT date FROM $table));
Op zaterdag 09 februari 2002 13:41, schreef Daniel Alsén:
Hi,
i can´t seem to get my head to wake up...
How would i do to count how many different values that exists in a mysql
field? Ie i have a date-field and need to
Hi,
i can?t seem to get my head to wake up...
How would i do to count how many different values that exists in a mysql
field? Ie i have a date-field and need to know how many different dates
that
exists in the table.
select count(distinct name) from site; in Mysql
Valentin Petruchek (aki
5 matches
Mail list logo