5 replies to this topic

[lol33d]

Hi guys

i have a list array and this list needed translation.


all cells array for translation stored in database record

i need a query for translate array with good method

Database Records is: 251251

and array list is now count: 152
Tomorrow: 5001
After tomorrow: 100

and this list change and uptodate

help me please

[WingedPanther]

It's going to be hard to help with this little information.

What is your database structure?
What is some sample data?
What should the transformation look like?

[lol33d]

database structure:

ID 	bigint(20) 	No  	  	  	 

STATUS 	enum('Enabled', 'Disabled') 	No  	Enabled  	  	 

LEVEL 	enum('Name', 'Family', 'Class') 	No  	Name  	  	 

ENNAME 	varchar(255) 	No  	  	  	 

CHNAME 	varchar(255) 	No  	  	  	 

DATE 	datetime 	No

LEVEL for keys array
ENNAME is orginal name and CHNAME is translate name
sample data:

$data = array(

				"Name"	=>	"Mikel", 

				"Name"	=>	"Alish", 

				"Name"	=>	"Mark", 

				"Name"	=>	"Duhe", 

				

				"Family"	=>	"Lois", 

				

				"Class"	=>	"Hogc", 

				"Class"	=>	"Hogc2", 

				"Class"	=>	"Hogc3", 

				

				"Family"	=>	"Nassi", 

				"Family"	=>	"Small");

thank you

[WingedPanther]

I'm not sure I clearly understand what you want to happen.

Currently, it seems like you could do a query for each item in your array to get the translation, but I'm guessing you want something a little different.

[lol33d]

i need translate array

[WingedPanther]

Can you give an example of input and output? I don't know what that means.