Re: [PHP] Big problem....need help
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 problemneed 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 problemneed 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 problemneed 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
Re: [PHP] Big problem....need help
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 problemneed 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 problemneed 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 problemneed 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
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 problemneed 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 problemneed 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
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 problemneed 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
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] Big problem....need help
I have a table like this:
- product_id-mark_name-category_name -
-1- aaa - catg 1 -
-2- bbb - catg 2 -
-3- aaa - catg 1 -
-4- ddd - catg 1 -
-5- bbb - catg 2 -
and so on
I want to show all the mark_name in a category only once (if they more than once)
I have this code:
..
$sql = "SELECT * FROM products, category WHERE
category.name_category=products.name_category and
category_id=".$_GET['category_id'] ;
$rezultat = mysql_query($sql);
while ($row=mysql_fetch_array($rezultat))
{
echo "Name: ".$row["mark_name"]."\n";
}
..
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
