Source language: Translate to:

add to var from mysql group field value, fields one of them

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

add to var from mysql group field value, fields one of them

Postby martincalatrava » Sat Jan 12, 2013 3:14 am

Hi, I have a mysql and with neobook connect all ok. Data are grouped, for example I have this:

Value: Field_Id: Item_id
test1 83 1
test2 84 1
test3 85 1
test4 83 2
test5 84 2
test6 85 2


I need to group by Item_id and add each Value into a var from all Item_id =1 for example
and have 3 vars each one with test1, test2 and test3 and show into a form to manage that
data (modify, etc..)

var1 = test1
var2 = test2
var3 = test3

Please help me.

Thanks a lot for your support
martincalatrava
 
Posts: 68
Joined: Fri Sep 01, 2006 2:18 am
Location: Tres Cantos - Madrid

Re: add to var from mysql group field value, fields one of t

Postby Gaev » Sat Jan 12, 2013 5:36 am

martincalatrava:

I am having difficulty understanding what results you are seeking.

Can you provide a specific example (records with real values) ... and what the resulting variables & values should be ?

Also, how many records do you expect to process with each run ?

Finally, please explain (in detail) what you mean by show into a form to manage that data (modify, etc..).
User avatar
Gaev
 
Posts: 3717
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Re: add to var from mysql group field value, fields one of t

Postby martincalatrava » Sat Jan 12, 2013 10:55 am

Hi and thanks ;)

I have one mysql table. The only field identification is into field_id value "83" "84" etc... the record into table that identified
the group registry is into item_id

For example, record one is all fields into item_id field and the identification for each value of the record is stored into field_id

* One record in table is divided into fields. I need how to locate each value of each record into variables


I hope this helps to you to help me.

;)
martincalatrava
 
Posts: 68
Joined: Fri Sep 01, 2006 2:18 am
Location: Tres Cantos - Madrid

Re: add to var from mysql group field value, fields one of t

Postby Gaev » Sun Jan 13, 2013 8:42 am

martincalatrava:
I hope this helps to you to help me.

Sorry, it does not.

Show a real example ... with about 10 records ... each with a real value ... 1, 2 and 83, 84 & 85 are real values ... not sure what test1 to test 6 are ... are they different text strings ? ... or more numbers ?

Then show exactly how you want the results to show i.e. do real calculations (manually) ... so script for doing it can be suggested.
User avatar
Gaev
 
Posts: 3717
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest