Converting data from MySQL database to usable values

[udka]

---

1) Why is it a 2x2 array ?

- A table is a collection of related data held in a structured format within a database. It consists of columns, and rows.

---

2) How do i take a selected value for example. i only want to the value 3333 to be taken out from database. 

- You can use Index Array and give proper row and column index to get the element in array.

---

3) How do i add the 3rd (3333) number and 4th (4444) number from database after getting the value out from array?

---

-After indexing elements you can use Add Function

---

4) I am a beginner in labview and all other programming. Is there any way to learn ? 

- There are free online tutorials available:

LabVIEW Introduction Course - Three Hours
LabVIEW Introduction Course - Six Hours

Learn LabVIEW Basics

NI Learning Center

[1K Post]

Edit: Also you can check the examples shipped along with labview Help->Find Examples and Context Help by pressing Ctrl+H.

[S.Neo]

Hi Udka,

I want the data to up date every 1 min interval is there any better way going about this beside adding a while loop to it ? If I were to use while loop, the program will have to open and close the database every loop while i think it is not very practical. But i can't think of another way to do it. 

[PalanivelThiruvenkadam]

---

@S.Neo wrote:

 If I were to use while loop, the program will have to open and close the database every loop while i think it is not very practical. But i can't think of another way to do it. 

---

You can create a VI With different cases as OPEN, READ,CLOSE of database, Keep the Reference in the shitregister, call the OPEN and CLOSE cases before and after Loop, call READ case Inside Loop.