and also id (either cat or subcat) can be called
- Original Message -
From: "HaidarPesebe"
To: "MySQL Lists"
Sent: Wednesday, May 30, 2012 2:31 PM
Subject: Re: category with parentid
Hello ts. Tanaka,
I've tried your way and succeed. Thank you.
But I wa
Hello ts. Tanaka,
I've tried your way and succeed. Thank you.
But I want to ask your help again what if the result will be like this:
A. Cat A
- Subcat A
- Subcat A
2. CatB
- Subcat B
possible by using or
which the previous result is
Cat A - SubcatA, SubcatA
Cat B - SubcatB
Thanks for the information;
I tried to call the database with something like this;
select id,name from TABLE WHERE parentid='0'
and a second call to the same table as this;
select id,name from TABLE WHERE parentid='$id' (this $id is the result of
calling the first call TABLE)
and successful
I have a database for the category
id | name | parentid
--
1 | cat A | 0
2 | cat B | 0
3 | subcat A | 1
4 | subcat A | 1
5 | subncat B | 2
-
I want to display the result like this:
1. Cat A
- Subcat A
- Subcat A
2. CatB
-
rom: "HaidarPesebe"
>
> I asked for help, how to order that each time I add an item then the
> item number in column 1 move to column 2, column 2 moves to the
> column 3, column 3 to 4 and so on.
>
> product | 1 | 2 | 3 | 4 | total
> [...]
What a most peculi
Exactly what you are saying Mr. Sándor. I tried adding a recordamount of debt
then becomes a multiple of 4. Well I'm really confused. Are there any who can
help? how to call the databaseby entering on the right?
- Original Message -
From: HaidarPesebe
To: MySQL Lists
d| bsemester | remark | bqty(USD)
-
1 | jon | 2010-2011| 1| paper| 7
2 | jon | 2010-2011| 1| mouse | 4
Thanks,
Haidarpesebe
__ Information from
I've tried it and succeeded. Thanks for the help Mr. Misra.
Best regards,
Haidarpesebe
.
- Original Message -
From: "Aveek Misra"
To: "HaidarPesebe"
Cc: "MySQL Lists"
Sent: Monday, June 20, 2011 11:28 AM
Subject: Re: calculate the total amount
Please help us calculate the total amount of revenue each month-year from the
two databases below. The first database is the name of the item and price. The
second database is the goods sold. I Will Make a recapitulation of every month
to my total income (total only). I've always tried but faile
Please help calculate the total revenue from the two databases below. The first
database is the name of the item and price. The second database is the goods
sold. I will make a recapitulation of every month to my total income (total
only). I've tried tp always failed.
TABLE A (item name and pr
Thanks a lot.
- Original Message -
From: Claudio Nanni
To: HaidarPesebe
Cc: MySQL Lists
Sent: Tuesday, April 12, 2011 12:55 PM
Subject: Re: call the data if more than one id
In (2,3,4)
On Apr 12, 2011 7:53 AM, "HaidarPesebe" wrote:
> please help m
please help me how to call the data if more than one id. Eg SELECT * FROM news
WHERE id = 2, 3 and 4
Thanks.
__ Information from ESET NOD32 Antivirus, version of virus signature
database 6034 (20110411) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
I've tried it and succeeded. thanks mark
- Original Message -
From: HaidarPesebe
To: MySQL Lists
Sent: Thursday, November 11, 2010 4:00 PM
Subject: backfill results for the same month and year
Dear All,
I have the following data
ID CITY QTY MONTH
2010
ID = ID PRODUCT.
How can I backfill results with the same ID by month and year, with results
like this:
MONTH/YEARQTY TOTAL
---
11/201086
10/201066
and etc.
Please help
Thanks
haidarpesebe
I tried this and succeeded. Thank you
SELECT product_id, isbn, name, author, harga, discount, sum(qty) as totalqty
FROM " . $prefix . "_sales_report b INNER JOIN " . $prefix . "_product p ON
(p.product_id = b.bid) GROUP BY b.bid ORDER BY totalqty DESC
haidarpesebe
--
n 'product.product_id' in 'field list'
Note: product_id (product) = bid (sales_report)
haidarpesebe
- Original Message -
From: "Aveek Misra"
To: "HaidarPesebe"
Cc: "MySQL Lists"
Sent: Wednesday, November 10, 2010 5:38 PM
Subject: Re:
please help us look for the data select from two tables with the following
details:
Primary table: product
ID | ProductName | ISBN |
---
1 | Product A | 123 |
2 | Product B | 456 |
3 | product C | 444 |
---
second table: salesreport
Total_Quantity FROM salesreport, product WHERE product.ID = salesreport.ID
GROUP BY salesreport.ID ORDER BY Total_Quantity DESC;
On Nov 10, 2010, at 3:53 PM, HaidarPesebe wrote:
> please help us look for the data select from two tables with the following
> details:
>
> Primary ta
Thanks for your information, we have tried it and solve my problems.
Thanks.
- Original Message -
From: Miguel Vaz
To: HaidarPesebe
Cc: MySQL Lists
Sent: Wednesday, August 04, 2010 1:40 AM
Subject: Re: from excel to the mySQL
Hi,
Ive always used navicat for mysql
do not insert bogus display names into the email display name (such as
Vaz when your real name is haidarpesebe)
most responsible mail-admins wont tolerate this type of spoofing or any type
of email spoofing
and if your name is VAZ use the email address created for VAZ instead of
haidarpesebe
Dear All,
I'm needs a way to upload data from excel to the mySQL database. Dear all, I
need help is how to upload data from excel columns and load into mysql database
using php?
Thanks
HaidarPesebe
Dear Mr. Wang,
I've tried and the results are in accordance with the intended.
Your description is very brief and precise
Thank you Mr. Wang.
With best regard,
Haidar Pesebe
- Original Message -
From: "HaidarPesebe"
To: "Yang Wang" ; "MySQL Lists"
Thanks Mr. Wang,
I will try and inform you again if have a problem.
Best regard,
Haidar Pesebe
- Original Message -
From: "Yang Wang"
To: "HaidarPesebe" ; "MySQL Lists"
Sent: Monday, December 21, 2009 5:22 PM
Subject: Re: Most data sort
sample as
r the result
will look like this
A = 7
C = 6
B = 3
D = 1
Thanks a lot
Haidarpesebe
'%$query%' or title
LIKE '%$query%' or author LIKE '%$query%'
for information id in bookcatalog and pricelist are same.
thanks a lot
Haidarpesebe
25 matches
Mail list logo
