ElaKiri Community
Downloads
Go Back   ElaKiri Community > General > ElaKiri Talk!
Reload this Page MYSQL Query Help ~
Reply
 
Thread Tools
(#1)
Old
MihiCherub's Avatar
MihiCherub MihiCherub is online now
Senior Member
MihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to all
 
Posts: 11,015
Join Date: Sep 2009
Location: No:██████, Gampaha
Send a message via Skype™ to MihiCherub
sad MYSQL Query Help ~ - 04-21-2017, 04:24 PM

MYSQL
මචන්ල මට මෙන්න මේකට හොද විසදුමක් දියල්ලකො..

මගේ MYSQL DB එකෙන් data load කරගන්න ඕනෙ combobox එකකට. Products කියල table එකක් තියෙනව. මේ table එකෙ තියෙන main category and sub category වල distinct values load කරගන්න ඕනෙ.

තව warehouse කියල table එකක warehouse names ටික තියෙනව මේ names ටිකත් combobox එකකට load කරගන්න ඕනෙ. මේ ඔක්කොම තනි query එකකින් කරගන්න පුලුවන්ද?

දැනට කරන්නෙ query 3ක් යවල.

Code:
SELECT DISTINCT main_cat FROM products ORDER BY main_cat

SELECT DISTINCT sub_cat FROM products ORDER BY sub_cat

SELECT DISTINCT wh_name FROM warehouse ORDER BY wh_name
Reply With Quote
(#2)
Old
u_make_me_sick_'s Avatar
u_make_me_sick_ u_make_me_sick_ is offline
Senior Member
u_make_me_sick_ has a spectacular aura aboutu_make_me_sick_ has a spectacular aura aboutu_make_me_sick_ has a spectacular aura about
 
Posts: 5,121
Join Date: Oct 2011
04-21-2017, 04:27 PM

Ey serin sere load karanne, eka serayak load karala cache karala thiya ganinko, oya data nithara wenas wena eewa newe neda? Use ehcache or mem cache.
Reply With Quote
(#3)
Old
ObeliX's Avatar
ObeliX ObeliX is offline
Senior Member
ObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of lightObeliX is a glorious beacon of light
 
Posts: 1,130
Join Date: Nov 2015
Location: Armocia
04-21-2017, 04:29 PM

bump
Reply With Quote
(#4)
Old
MihiCherub's Avatar
MihiCherub MihiCherub is online now
Senior Member
MihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to all
 
Posts: 11,015
Join Date: Sep 2009
Location: No:██████, Gampaha
Send a message via Skype™ to MihiCherub
04-21-2017, 04:30 PM

Quote:
Originally Posted by u_make_me_sick_ View Post
Ey serin sere load karanne, eka serayak load karala cache karala thiya ganinko, oya data nithara wenas wena eewa newe neda? Use ehcache or mem cache.
ba machan Item registration ekedi kipadenek data feed karanawane. e nisa hama save ekakidima load karanna one.
Reply With Quote
(#5)
Old
u_make_me_sick_'s Avatar
u_make_me_sick_ u_make_me_sick_ is offline
Senior Member
u_make_me_sick_ has a spectacular aura aboutu_make_me_sick_ has a spectacular aura aboutu_make_me_sick_ has a spectacular aura about
 
Posts: 5,121
Join Date: Oct 2011
04-21-2017, 04:33 PM

Oya tables join welada thiyenne fk ekakin?
Reply With Quote
(#6)
Old
Executer's Avatar
Executer Executer is online now
Awrudu Games 2017 - Winners
Executer has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud ofExecuter has much to be proud of
 
Posts: 13,402
Join Date: Jan 2013
Location: ★★★★★Cutting Edge★★★★★
04-21-2017, 04:35 PM

bump
Reply With Quote
(#7)
Old
MihiCherub's Avatar
MihiCherub MihiCherub is online now
Senior Member
MihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to allMihiCherub is a name known to all
 
Posts: 11,015
Join Date: Sep 2009
Location: No:██████, Gampaha
Send a message via Skype™ to MihiCherub
04-21-2017, 04:36 PM

Quote:
Originally Posted by u_make_me_sick_ View Post
Oya tables join welada thiyenne fk ekakin?
mama me poddai ban danme... mage combobox 12k load wenawa. ekai me baluwe.

ow join wela thyenne fk thiyenawa.
Reply With Quote
(#8)
Old
Franklin EK's Avatar
Franklin EK Franklin EK is offline
Senior Member
Franklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of lightFranklin EK is a glorious beacon of light
 
Posts: 2,742
Join Date: Mar 2017
Location: කැලෑවක
04-21-2017, 04:46 PM

..B U M P..
Reply With Quote
(#9)
Old
ryandok's Avatar
ryandok ryandok is offline
Senior Member
ryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to beholdryandok is a splendid one to behold
 
Posts: 8,740
Join Date: Oct 2011
Location: වලපල්ලේ
04-21-2017, 04:49 PM

bump
Reply With Quote
(#10)
Old
Arrow11's Avatar
Arrow11 Arrow11 is online now
Senior Member
Arrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to allArrow11 is a name known to all
 
Posts: 11,589
Join Date: May 2014
Location: හීන මාලිගාවේ ❤❤
04-21-2017, 04:55 PM

Danna taramin ba kollo
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Copyright © 2006 - 2011 ElaKiri™ Beta2.Evo vBulletin, vBa iBproArcade Subdreamer I-Magic MKv

Page generated in 0.02128 seconds with 11 queries