First, you might want to use more descriptive subjects. That might
describe your urgency, but it doesn't tell us what you need.
As for the question, try this:
$sql = "SELECT *, count(products.mark_name) as count
FROM products, category
WHERE category.name_category=products.name_category
AND category_id=".$_GET['category_id']."
GROUP BY products.mark_name";
but if you don't need all the other data in the rows, just do this:
$sql = "SELECT p.mark_name, count(p.mark_name) as count
FROM products as p, category as c
WHERE c.name_category=p.name_category
AND category_id=".$_GET['category_id']."
GROUP BY p.mark_name";
--- phpu <[EMAIL PROTECTED]> wrote:
> 10x a lot. it worked.
> Now I have another problem. How to find the number of the records
> in the table.
> this is the way i want (in this case}
>
> Name: aaa 2 times
> Name ddd 1 times
>
> Please help with this one
>
>
>
>
> ----- Original Message -----
> From: Haseeb
> To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Sent: Thursday, July 10, 2003 8:18 AM
> Subject: Re: [PHP] Big problem....need help
>
>
> try like this
>
> $sql = "SELECT * FROM products, category WHERE
> category.name_category=products.name_category and
> category_id=".$_GET['category_id']." GROUP BY products.mark_name";
>
>
>
>
>
> -------Original Message-------
>
> From: phpu
> Date: Wednesday, July 09, 2003 09:51:08 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Big problem....need help
>
> It isn't work. it gives me an error at this line.
>
> ----- Original Message -----
> From: "Nicolas Costes"
> <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, July 09, 2003 4:49 PM
> Subject: Re: [PHP] Big problem....need help
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Le Mercredi 9 Juillet 2003 15:13, phpu a écrit :
> > I have a table like this:
>
> > ......
> > $sql = "SELECT * FROM products, category WHERE
> > category.name_category=products.name_category and
> > category_id=".$_GET['category_id'] ;
>
> >
> > When i choose the category catg 1 the result is
> > Name: aaa
> > Name: aaa
> > Name: ddd
> >
> > As you can see the name aaa appears 2 times insted 1.
> > How to make the result look like this:
> > Name: aaa
> > Name: ddd
>
> Use "GROUP BY" ....
>
> $sql = "SELECT * FROM products, category WHERE
> category.name_category=products.name_category and
> category_id=".$_GET['category_id'] GROUP BY
> products.mark_name;
>
>
> - --
> ,,
> (°> Nicolas Costes
> /|\ IUT de La Roche / Yon
> ( ^ ) Clé publique: http://www.keyserver.net/
> ^ ^ http://www.gnu.org/philosophy/can-you-trust.fr.html
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
>
> iD8DBQE/DB2GNc2aXy7LuOgRAmE6AKCIeGpWg78san/72M7vbhwJXQKXbQCfVxAJ
> OgayWbAh0cOXc5OCdVy2uWs=
> =vH6U
> -----END PGP SIGNATURE-----
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> ____________________________________________________
> IncrediMail - Email has finally evolved - Click Here
>
=====
Mark Weinstock
[EMAIL PROTECTED]
***************************************
You can't demand something as a "right" unless you are willing to fight to death to
defend everyone else's right to the same thing.
***************************************
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
