Page 1 of 1

help designing a DB table and the sql query

Posted: Mon Jun 12, 2006 10:50 am
by alexislalas
i have the next table to fill.

Image


the problem i have, is that i dont know how to design the table to work properly.

for the moment i have a huge table with one field for each input you can see in the image and i dont think thats the way its done.


so what advice can you guys give me? also involving the correct sql query to make all those inputs.


thanks.

Posted: Mon Jun 12, 2006 1:46 pm
by Christopher
It is difficult to know exactly from looking at that image. Each row appears to be a database record, except the first field (subseccion) seems to specify the type of record. You would probably ORDER BY the first field and the View code would display the records grouped. But if the user changes the first field you will need to regenerate the page.

Posted: Mon Jun 12, 2006 3:29 pm
by alexislalas
my problem is not the output. its the insert into the database part.


how can I generate a query, or what does the databse has to look like, to put the fields in the image into the database.


so far i have a database that looks exactly like the image, and im almost 100% sure that that is not the right way to do it.

Posted: Mon Jun 12, 2006 3:37 pm
by tecktalkcm0391
What database type is it? And what are you trying to do? I am kinda confused. Do you want to add data, or update data?

Explain exactly what you want in detail.

Posted: Mon Jun 12, 2006 4:55 pm
by alexislalas
its a mysql database.

i want to insert, add new data.


the image shows a form of the users interphase when they want to insert the data.



whats troubling me is how the database should look. because i have a database table with more than 30 fields.


dont know if thats enough.

Posted: Tue Jun 13, 2006 10:07 am
by alexislalas
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


to get an idea, this is how my database looks like:

[syntax="sql"]CREATE TABLE `esqueleto_eda` (                           
                 `ID` int(11) NOT NULL auto_increment,                  
                 `NUMERO_REVISTA` int(10) default NULL,                 
                 `MES_PUBLICACION` varchar(100) default NULL,           
                 `ANIO_PUBLICACION` int(4) default NULL,                
                 `ATICO1_SECCION` varchar(255) default NULL,            
                 `ATICO1_SUBSECCION` varchar(255) default NULL,         
                 `ATICO1_ARTICULO` blob,                                
                 `ATICO1_AUTOR` blob,                                   
                 `ATICO1_V601_FECHAASIGNACION` date default NULL,       
                 `ATICO1_601_FECHA1ERENTREGA` date default NULL,        
                 `ATICO1_601_FECHARETRO` date default NULL,             
                 `ATICO1_601_FECHAFINAL` date default NULL,             
                 `ATICO1_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `ATICO1_604_PORAVANCE2` int(3) default NULL,           
                 `ATICO1_604_PORAVANCE3` int(3) default NULL,           
                 `ATICO1_604_FINALED` varchar(100) default NULL,        
                 `ATICO1_604_PORAVANCE1` int(3) default NULL,           
                 `ATICO1_604_FECHAVANCE1` int(3) default NULL,          
                 `ATICO1_604_DEADLINE` date default NULL,               
                 `ATICO1_604_FECHAFINAL` date default NULL,             
                 `ATICO1_605_PORAVANCE1` int(3) default NULL,           
                 `ATICO1_605_FECHAAVANCE1` date default NULL,           
                 `ATICO1_605_FINALDISENO` date default NULL,            
                 `ATICO1_605_FECHAFINAL` date default NULL,             
                 `ATICO1_605_PORAVANCE1AN` int(3) default NULL,         
                 `ATICO1_605_FECHAAVANCE1AN` date default NULL,         
                 `ATICO1_605_DEADLINE` date default NULL,               
                 `ATICO1_605_FECHAFINALAN` date default NULL,           
                 `ATICO2_SECCION` varchar(255) default NULL,            
                 `ATICO2_SUBSECCION` varchar(255) default NULL,         
                 `ATICO2_ARTICULO` blob,                                
                 `ATICO2_AUTOR` blob,                                   
                 `ATICO2_601_FECHAASIGNACION` date default NULL,        
                 `ATICO2_601_FECHA1ERENTREGA` date default NULL,        
                 `ATICO2_601_FECHARETRO` date default NULL,             
                 `ATICO2_601_FECHAFINAL` date default NULL,             
                 `ATICO2_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `ATICO2_604_PORAVANCE2` int(3) default NULL,           
                 `ATICO2_604_PORAVANCE3` int(3) default NULL,           
                 `ATICO2_604_FINALED` varchar(100) default NULL,        
                 `ATICO2_604_PORAVANCE1` int(3) default NULL,           
                 `ATICO2_604_FECHAVANCE1` int(3) default NULL,          
                 `ATICO2_604_DEADLINE` date default NULL,               
                 `ATICO2_604_FECHAFINAL` date default NULL,             
                 `ATICO2_605_PORAVANCE1` int(3) default NULL,           
                 `ATICO2_605_FECHAAVANCE1` date default NULL,           
                 `ATICO2_605_FINALDISENO` date default NULL,            
                 `ATICO2_605_FECHAFINAL` date default NULL,             
                 `ATICO2_605_PORAVANCE1AN` int(3) default NULL,         
                 `ATICO2_605_FECHAAVANCE1AN` date default NULL,         
                 `ATICO2_605_DEADLINE` date default NULL,               
                 `ATICO2_605_FECHAFINALAN` date default NULL,           
                 `ATICO3_SECCION` varchar(255) default NULL,            
                 `ATICO3_SUBSECCION` varchar(255) default NULL,         
                 `ATICO3_ARTICULO` blob,                                
                 `ATICO3_AUTOR` blob,                                   
                 `ATICO3_601_FECHAASIGNACION` date default NULL,        
                 `ATICO3_601_FECHA1ERENTREGA` date default NULL,        
                 `ATICO3_601_FECHARETRO` date default NULL,             
                 `ATICO3_601_FECHAFINAL` date default NULL,             
                 `ATICO3_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `ATICO3_604_PORAVANCE2` int(3) default NULL,           
                 `ATICO3_604_PORAVANCE3` int(3) default NULL,           
                 `ATICO3_604_FINALED` varchar(100) default NULL,        
                 `ATICO3_604_PORAVANCE1` int(3) default NULL,           
                 `ATICO3_604_FECHAVANCE1` int(3) default NULL,          
                 `ATICO3_604_DEADLINE` date default NULL,               
                 `ATICO3_604_FECHAFINAL` date default NULL,             
                 `ATICO3_605_PORAVANCE1` int(3) default NULL,           
                 `ATICO3_605_FECHAAVANCE1` date default NULL,           
                 `ATICO3_605_FINALDISENO` date default NULL,            
                 `ATICO3_605_FECHAFINAL` date default NULL,             
                 `ATICO3_605_PORAVANCE1AN` int(3) default NULL,         
                 `ATICO3_605_FECHAAVANCE1AN` date default NULL,         
                 `ATICO3_605_DEADLINE` date default NULL,               
                 `ATICO3_605_FECHAFINALAN` date default NULL,           
                 `AGORA1_SECCION` varchar(255) default NULL,            
                 `AGORA1_SUBSECCION` varchar(255) default NULL,         
                 `AGORA1_ARTICULO` blob,                                
                 `AGORA1_AUTOR` blob,                                   
                 `AGORA1_601_FECHAASIGNACION` date default NULL,        
                 `AGORA1_601_FECHA1ERENTREGA` date default NULL,        
                 `AGORA1_601_FECHARETRO` date default NULL,             
                 `AGORA1_601_FECHAFINAL` date default NULL,             
                 `AGORA1_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `AGORA1_604_PORAVANCE2` int(3) default NULL,           
                 `AGORA1_604_PORAVANCE3` int(3) default NULL,           
                 `AGORA1_604_FINALED` varchar(100) default NULL,        
                 `AGORA1_604_PORAVANCE1` int(3) default NULL,           
                 `AGORA1_604_FECHAVANCE1` int(3) default NULL,          
                 `AGORA1_604_DEADLINE` date default NULL,               
                 `AGORA1_604_FECHAFINAL` date default NULL,             
                 `AGORA1_605_PORAVANCE1` int(3) default NULL,           
                 `AGORA1_605_FECHAAVANCE1` date default NULL,           
                 `AGORA1_605_FINALDISENO` date default NULL,            
                 `AGORA1_605_FECHAFINAL` date default NULL,             
                 `AGORA1_605_PORAVANCE1AN` int(3) default NULL,         
                 `AGORA1_605_FECHAAVANCE1AN` date default NULL,         
                 `AGORA1_605_DEADLINE` date default NULL,               
                 `AGORA1_605_FECHAFINALAN` date default NULL,           
                 `AGORA2_SECCION` varchar(255) default NULL,            
                 `AGORA2_SUBSECCION` varchar(255) default NULL,         
                 `AGORA2_ARTICULO` blob,                                
                 `AGORA2_AUTOR` blob,                                   
                 `AGORA2_601_FECHAASIGNACION` date default NULL,        
                 `AGORA2_601_FECHA1ERENTREGA` date default NULL,        
                 `AGORA2_601_FECHARETRO` date default NULL,             
                 `AGORA2_601_FECHAFINAL` date default NULL,             
                 `AGORA2_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `AGORA2_604_PORAVANCE2` int(3) default NULL,           
                 `AGORA2_604_PORAVANCE3` int(3) default NULL,           
                 `AGORA2_604_FINALED` varchar(100) default NULL,        
                 `AGORA2_604_PORAVANCE1` int(3) default NULL,           
                 `AGORA2_604_FECHAVANCE1` int(3) default NULL,          
                 `AGORA2_604_DEADLINE` date default NULL,               
                 `AGORA2_604_FECHAFINAL` date default NULL,             
                 `AGORA2_605_PORAVANCE1` int(3) default NULL,           
                 `AGORA2_605_FECHAAVANCE1` date default NULL,           
                 `AGORA2_605_FINALDISENO` date default NULL,            
                 `AGORA2_605_FECHAFINAL` date default NULL,             
                 `AGORA2_605_PORAVANCE1AN` int(3) default NULL,         
                 `AGORA2_605_FECHAAVANCE1AN` date default NULL,         
                 `AGORA2_605_DEADLINE` date default NULL,               
                 `AGORA2_605_FECHAFINALAN` date default NULL,           
                 `AGORA3_SECCION` varchar(255) default NULL,            
                 `AGORA3_SUBSECCION` varchar(255) default NULL,         
                 `AGORA3_ARTICULO` blob,                                
                 `AGORA3_AUTOR` blob,                                   
                 `AGORA3_601_FECHAASIGNACION` date default NULL,        
                 `AGORA3_601_FECHA1ERENTREGA` date default NULL,        
                 `AGORA3_601_FECHARETRO` date default NULL,             
                 `AGORA3_601_FECHAFINAL` date default NULL,             
                 `AGORA3_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `AGORA3_604_PORAVANCE2` int(3) default NULL,           
                 `AGORA3_604_PORAVANCE3` int(3) default NULL,           
                 `AGORA3_604_FINALED` varchar(100) default NULL,        
                 `AGORA3_604_PORAVANCE1` int(3) default NULL,           
                 `AGORA3_604_FECHAVANCE1` int(3) default NULL,          
                 `AGORA3_604_DEADLINE` date default NULL,               
                 `AGORA3_604_FECHAFINAL` date default NULL,             
                 `AGORA3_605_PORAVANCE1` int(3) default NULL,           
                 `AGORA3_605_FECHAAVANCE1` date default NULL,           
                 `AGORA3_605_FINALDISENO` date default NULL,            
                 `AGORA3_605_FECHAFINAL` date default NULL,             
                 `AGORA3_605_PORAVANCE1AN` int(3) default NULL,         
                 `AGORA3_605_FECHAAVANCE1AN` date default NULL,         
                 `AGORA3_605_DEADLINE` date default NULL,               
                 `AGORA3_605_FECHAFINALAN` date default NULL,           
                 `AGORA4_SECCION` varchar(255) default NULL,            
                 `AGORA4_SUBSECCION` varchar(255) default NULL,         
                 `AGORA4_ARTICULO` blob,                                
                 `AGORA4_AUTOR` blob,                                   
                 `AGORA4_601_FECHAASIGNACION` date default NULL,        
                 `AGORA4_601_FECHA1ERENTREGA` date default NULL,        
                 `AGORA4_601_FECHARETRO` date default NULL,             
                 `AGORA4_601_FECHAFINAL` date default NULL,             
                 `AGORA4_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `AGORA4_604_PORAVANCE2` int(3) default NULL,           
                 `AGORA4_604_PORAVANCE3` int(3) default NULL,           
                 `AGORA4_604_FINALED` varchar(100) default NULL,        
                 `AGORA4_604_PORAVANCE1` int(3) default NULL,           
                 `AGORA4_604_FECHAVANCE1` int(3) default NULL,          
                 `AGORA4_604_DEADLINE` date default NULL,               
                 `AGORA4_604_FECHAFINAL` date default NULL,             
                 `AGORA4_605_PORAVANCE1` int(3) default NULL,           
                 `AGORA4_605_FECHAAVANCE1` date default NULL,           
                 `AGORA4_605_FINALDISENO` date default NULL,            
                 `AGORA4_605_FECHAFINAL` date default NULL,             
                 `AGORA4_605_PORAVANCE1AN` int(3) default NULL,         
                 `AGORA4_605_FECHAAVANCE1AN` date default NULL,         
                 `AGORA4_605_DEADLINE` date default NULL,               
                 `AGORA4_605_FECHAFINALAN` date default NULL,           
                 `VISION1_SECCION` varchar(255) default NULL,           
                 `VISION1_SUBSECCION` varchar(255) default NULL,        
                 `VISION1_ARTICULO` blob,                               
                 `VISION1_AUTOR` blob,                                  
                 `VISION1_601_FECHAASIGNACION` date default NULL,       
                 `VISION1_601_FECHA1ERENTREGA` date default NULL,       
                 `VISION1_601_FECHARETRO` date default NULL,            
                 `VISION1_601_FECHAFINAL` date default NULL,            
                 `VISION1_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `VISION1_604_PORAVANCE2` int(3) default NULL,          
                 `VISION1_604_PORAVANCE3` int(3) default NULL,          
                 `VISION1_604_FINALED` varchar(100) default NULL,       
                 `VISION1_604_PORAVANCE1` int(3) default NULL,          
                 `VISION1_604_FECHAVANCE1` int(3) default NULL,         
                 `VISION1_604_DEADLINE` date default NULL,              
                 `VISION1_604_FECHAFINAL` date default NULL,            
                 `VISION1_605_PORAVANCE1` int(3) default NULL,          
                 `VISION1_605_FECHAAVANCE1` date default NULL,          
                 `VISION1_605_FINALDISENO` date default NULL,           
                 `VISION1_605_FECHAFINAL` date default NULL,            
                 `VISION1_605_PORAVANCE1AN` int(3) default NULL,        
                 `VISION1_605_FECHAAVANCE1AN` date default NULL,        
                 `VISION1_605_DEADLINE` date default NULL,              
                 `VISION1_605_FECHAFINALAN` date default NULL,          
                 `VISION2_SECCION` varchar(255) default NULL,           
                 `VISION2_SUBSECCION` varchar(255) default NULL,        
                 `VISION2_ARTICULO` blob,                               
                 `VISION2_AUTOR` blob,                                  
                 `VISION2_601_FECHAASIGNACION` date default NULL,       
                 `VISION2_601_FECHA1ERENTREGA` date default NULL,       
                 `VISION2_601_FECHARETRO` date default NULL,            
                 `VISION2_601_FECHAFINAL` date default NULL,            
                 `VISION2_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `VISION2_604_PORAVANCE2` int(3) default NULL,          
                 `VISION2_604_PORAVANCE3` int(3) default NULL,          
                 `VISION2_604_FINALED` varchar(100) default NULL,       
                 `VISION2_604_PORAVANCE1` int(3) default NULL,          
                 `VISION2_604_FECHAVANCE1` int(3) default NULL,         
                 `VISION2_604_DEADLINE` date default NULL,              
                 `VISION2_604_FECHAFINAL` date default NULL,            
                 `VISION2_605_PORAVANCE1` int(3) default NULL,          
                 `VISION2_605_FECHAAVANCE1` date default NULL,          
                 `VISION2_605_FINALDISENO` date default NULL,           
                 `VISION2_605_FECHAFINAL` date default NULL,            
                 `VISION2_605_PORAVANCE1AN` int(3) default NULL,        
                 `VISION2_605_FECHAAVANCE1AN` date default NULL,        
                 `VISION2_605_DEADLINE` date default NULL,              
                 `VISION2_605_FECHAFINALAN` date default NULL,          
                 `VISION3_SECCION` varchar(255) default NULL,           
                 `VISION3_SUBSECCION` varchar(255) default NULL,        
                 `VISION3_ARTICULO` blob,                               
                 `VISION3_AUTOR` blob,                                  
                 `VISION3_601_FECHAASIGNACION` date default NULL,       
                 `VISION3_601_FECHA1ERENTREGA` date default NULL,       
                 `VISION3_601_FECHARETRO` date default NULL,            
                 `VISION3_601_FECHAFINAL` date default NULL,            
                 `VISION3_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `VISION3_604_PORAVANCE2` int(3) default NULL,          
                 `VISION3_604_PORAVANCE3` int(3) default NULL,          
                 `VISION3_604_FINALED` varchar(100) default NULL,       
                 `VISION3_604_PORAVANCE1` int(3) default NULL,          
                 `VISION3_604_FECHAVANCE1` int(3) default NULL,         
                 `VISION3_604_DEADLINE` date default NULL,              
                 `VISION3_604_FECHAFINAL` date default NULL,            
                 `VISION3_605_PORAVANCE1` int(3) default NULL,          
                 `VISION3_605_FECHAAVANCE1` date default NULL,          
                 `VISION3_605_FINALDISENO` date default NULL,           
                 `VISION3_605_FECHAFINAL` date default NULL,            
                 `VISION3_605_PORAVANCE1AN` int(3) default NULL,        
                 `VISION3_605_FECHAAVANCE1AN` date default NULL,        
                 `VISION3_605_DEADLINE` date default NULL,              
                 `VISION3_605_FECHAFINALAN` date default NULL,          
                 `VISION4_SECCION` varchar(255) default NULL,           
                 `VISION4_SUBSECCION` varchar(255) default NULL,        
                 `VISION4_ARTICULO` blob,                               
                 `VISION4_AUTOR` blob,                                  
                 `VISION4_601_FECHAASIGNACION` date default NULL,       
                 `VISION4_601_FECHA1ERENTREGA` date default NULL,       
                 `VISION4_601_FECHARETRO` date default NULL,            
                 `VISION4_601_FECHAFINAL` date default NULL,            
                 `VISION4_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `VISION4_604_PORAVANCE2` int(3) default NULL,          
                 `VISION4_604_PORAVANCE3` int(3) default NULL,          
                 `VISION4_604_FINALED` varchar(100) default NULL,       
                 `VISION4_604_PORAVANCE1` int(3) default NULL,          
                 `VISION4_604_FECHAVANCE1` int(3) default NULL,         
                 `VISION4_604_DEADLINE` date default NULL,              
                 `VISION4_604_FECHAFINAL` date default NULL,            
                 `VISION4_605_PORAVANCE1` int(3) default NULL,          
                 `VISION4_605_FECHAAVANCE1` date default NULL,          
                 `VISION4_605_FINALDISENO` date default NULL,           
                 `VISION4_605_FECHAFINAL` date default NULL,            
                 `VISION4_605_PORAVANCE1AN` int(3) default NULL,        
                 `VISION4_605_FECHAAVANCE1AN` date default NULL,        
                 `VISION4_605_DEADLINE` date default NULL,              
                 `VISION4_605_FECHAFINALAN` date default NULL,          
                 `ANDROM1_SECCION` varchar(255) default NULL,           
                 `ANDROM1_SUBSECCION` varchar(255) default NULL,        
                 `ANDROM1_ARTICULO` blob,                               
                 `ANDROM1_AUTOR` blob,                                  
                 `ANDROM1_601_FECHAASIGNACION` date default NULL,       
                 `ANDROM1_601_FECHA1ERENTREGA` date default NULL,       
                 `ANDROM1_601_FECHARETRO` date default NULL,            
                 `ANDROM1_601_FECHAFINAL` date default NULL,            
                 `ANDROM1_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `ANDROM1_604_PORAVANCE2` int(3) default NULL,          
                 `ANDROM1_604_PORAVANCE3` int(3) default NULL,          
                 `ANDROM1_604_FINALED` varchar(100) default NULL,       
                 `ANDROM1_604_PORAVANCE1` int(3) default NULL,          
                 `ANDROM1_604_FECHAVANCE1` int(3) default NULL,         
                 `ANDROM1_604_DEADLINE` date default NULL,              
                 `ANDROM1_604_FECHAFINAL` date default NULL,            
                 `ANDROM1_605_PORAVANCE1` int(3) default NULL,          
                 `ANDROM1_605_FECHAAVANCE1` date default NULL,          
                 `ANDROM1_605_FINALDISENO` date default NULL,           
                 `ANDROM1_605_FECHAFINAL` date default NULL,            
                 `ANDROM1_605_PORAVANCE1AN` int(3) default NULL,        
                 `ANDROM1_605_FECHAAVANCE1AN` date default NULL,        
                 `ANDROM1_605_DEADLINE` date default NULL,              
                 `ANDROM1_605_FECHAFINALAN` date default NULL,          
                 `ANDROM2_SECCION` varchar(255) default NULL,           
                 `ANDROM2_SUBSECCION` varchar(255) default NULL,        
                 `ANDROM2_ARTICULO` blob,                               
                 `ANDROM2_AUTOR` blob,                                  
                 `ANDROM2_601_FECHAASIGNACION` date default NULL,       
                 `ANDROM2_601_FECHA1ERENTREGA` date default NULL,       
                 `ANDROM2_601_FECHARETRO` date default NULL,            
                 `ANDROM2_601_FECHAFINAL` date default NULL,            
                 `ANDROM2_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `ANDROM2_604_PORAVANCE2` int(3) default NULL,          
                 `ANDROM2_604_PORAVANCE3` int(3) default NULL,          
                 `ANDROM2_604_FINALED` varchar(100) default NULL,       
                 `ANDROM2_604_PORAVANCE1` int(3) default NULL,          
                 `ANDROM2_604_FECHAVANCE1` int(3) default NULL,         
                 `ANDROM2_604_DEADLINE` date default NULL,              
                 `ANDROM2_604_FECHAFINAL` date default NULL,            
                 `ANDROM2_605_PORAVANCE1` int(3) default NULL,          
                 `ANDROM2_605_FECHAAVANCE1` date default NULL,          
                 `ANDROM2_605_FINALDISENO` date default NULL,           
                 `ANDROM2_605_FECHAFINAL` date default NULL,            
                 `ANDROM2_605_PORAVANCE1AN` int(3) default NULL,        
                 `ANDROM2_605_FECHAAVANCE1AN` date default NULL,        
                 `ANDROM2_605_DEADLINE` date default NULL,              
                 `ANDROM2_605_FECHAFINALAN` date default NULL,          
                 `ANDROM3_SECCION` varchar(255) default NULL,           
                 `ANDROM3_SUBSECCION` varchar(255) default NULL,        
                 `ANDROM3_ARTICULO` blob,                               
                 `ANDROM3_AUTOR` blob,                                  
                 `ANDROM3_601_FECHAASIGNACION` date default NULL,       
                 `ANDROM3_601_FECHA1ERENTREGA` date default NULL,       
                 `ANDROM3_601_FECHARETRO` date default NULL,            
                 `ANDROM3_601_FECHAFINAL` date default NULL,            
                 `ANDROM3_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `ANDROM3_604_PORAVANCE2` int(3) default NULL,          
                 `ANDROM3_604_PORAVANCE3` int(3) default NULL,          
                 `ANDROM3_604_FINALED` varchar(100) default NULL,       
                 `ANDROM3_604_PORAVANCE1` int(3) default NULL,          
                 `ANDROM3_604_FECHAVANCE1` int(3) default NULL,         
                 `ANDROM3_604_DEADLINE` date default NULL,              
                 `ANDROM3_604_FECHAFINAL` date default NULL,            
                 `ANDROM3_605_PORAVANCE1` int(3) default NULL,          
                 `ANDROM3_605_FECHAAVANCE1` date default NULL,          
                 `ANDROM3_605_FINALDISENO` date default NULL,           
                 `ANDROM3_605_FECHAFINAL` date default NULL,            
                 `ANDROM3_605_PORAVANCE1AN` int(3) default NULL,        
                 `ANDROM3_605_FECHAAVANCE1AN` date default NULL,        
                 `ANDROM3_605_DEADLINE` date default NULL,              
                 `ANDROM3_605_FECHAFINALAN` date default NULL,          
                 `ANDROM4_SECCION` varchar(255) default NULL,           
                 `ANDROM4_SUBSECCION` varchar(255) default NULL,        
                 `ANDROM4_ARTICULO` blob,                               
                 `ANDROM4_AUTOR` blob,                                  
                 `ANDROM4_601_FECHAASIGNACION` date default NULL,       
                 `ANDROM4_601_FECHA1ERENTREGA` date default NULL,       
                 `ANDROM4_601_FECHARETRO` date default NULL,            
                 `ANDROM4_601_FECHAFINAL` date default NULL,            
                 `ANDROM4_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `ANDROM4_604_PORAVANCE2` int(3) default NULL,          
                 `ANDROM4_604_PORAVANCE3` int(3) default NULL,          
                 `ANDROM4_604_FINALED` varchar(100) default NULL,       
                 `ANDROM4_604_PORAVANCE1` int(3) default NULL,          
                 `ANDROM4_604_FECHAVANCE1` int(3) default NULL,         
                 `ANDROM4_604_DEADLINE` date default NULL,              
                 `ANDROM4_604_FECHAFINAL` date default NULL,            
                 `ANDROM4_605_PORAVANCE1` int(3) default NULL,          
                 `ANDROM4_605_FECHAAVANCE1` date default NULL,          
                 `ANDROM4_605_FINALDISENO` date default NULL,           
                 `ANDROM4_605_FECHAFINAL` date default NULL,            
                 `ANDROM4_605_PORAVANCE1AN` int(3) default NULL,        
                 `ANDROM4_605_FECHAAVANCE1AN` date default NULL,        
                 `ANDROM4_605_DEADLINE` date default NULL,              
                 `ANDROM4_605_FECHAFINALAN` date default NULL,          
                 `EQUIL1_SECCION` varchar(255) default NULL,            
                 `EQUIL1_SUBSECCION` varchar(255) default NULL,         
                 `EQUIL1_ARTICULO` blob,                                
                 `EQUIL1_AUTOR` blob,                                   
                 `EQUIL1_601_FECHAASIGNACION` date default NULL,        
                 `EQUIL1_601_FECHA1ERENTREGA` date default NULL,        
                 `EQUIL1_601_FECHARETRO` date default NULL,             
                 `EQUIL1_601_FECHAFINAL` date default NULL,             
                 `EQUIL1_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `EQUIL1_604_PORAVANCE2` int(3) default NULL,           
                 `EQUIL1_604_PORAVANCE3` int(3) default NULL,           
                 `EQUIL1_604_FINALED` varchar(100) default NULL,        
                 `EQUIL1_604_PORAVANCE1` int(3) default NULL,           
                 `EQUIL1_604_FECHAVANCE1` int(3) default NULL,          
                 `EQUIL1_604_DEADLINE` date default NULL,               
                 `EQUIL1_604_FECHAFINAL` date default NULL,             
                 `EQUIL1_605_PORAVANCE1` int(3) default NULL,           
                 `EQUIL1_605_FECHAAVANCE1` date default NULL,           
                 `EQUIL1_605_FINALDISENO` date default NULL,            
                 `EQUIL1_605_FECHAFINAL` date default NULL,             
                 `EQUIL1_605_PORAVANCE1AN` int(3) default NULL,         
                 `EQUIL1_605_FECHAAVANCE1AN` date default NULL,         
                 `EQUIL1_605_DEADLINE` date default NULL,               
                 `EQUIL1_605_FECHAFINALAN` date default NULL,           
                 `EQUIL2_SECCION` varchar(255) default NULL,            
                 `EQUIL2_SUBSECCION` varchar(255) default NULL,         
                 `EQUIL2_ARTICULO` blob,                                
                 `EQUIL2_AUTOR` blob,                                   
                 `EQUIL2_601_FECHAASIGNACION` date default NULL,        
                 `EQUIL2_601_FECHA1ERENTREGA` date default NULL,        
                 `EQUIL2_601_FECHARETRO` date default NULL,             
                 `EQUIL2_601_FECHAFINAL` date default NULL,             
                 `EQUIL2_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `EQUIL2_604_PORAVANCE2` int(3) default NULL,           
                 `EQUIL2_604_PORAVANCE3` int(3) default NULL,           
                 `EQUIL2_604_FINALED` varchar(100) default NULL,        
                 `EQUIL2_604_PORAVANCE1` int(3) default NULL,           
                 `EQUIL2_604_FECHAVANCE1` int(3) default NULL,          
                 `EQUIL2_604_DEADLINE` date default NULL,               
                 `EQUIL2_604_FECHAFINAL` date default NULL,             
                 `EQUIL2_605_PORAVANCE1` int(3) default NULL,           
                 `EQUIL2_605_FECHAAVANCE1` date default NULL,           
                 `EQUIL2_605_FINALDISENO` date default NULL,            
                 `EQUIL2_605_FECHAFINAL` date default NULL,             
                 `EQUIL2_605_PORAVANCE1AN` int(3) default NULL,         
                 `EQUIL2_605_FECHAAVANCE1AN` date default NULL,         
                 `EQUIL2_605_DEADLINE` date default NULL,               
                 `EQUIL2_605_FECHAFINALAN` date default NULL,           
                 `EQUIL3_SECCION` varchar(255) default NULL,            
                 `EQUIL3_SUBSECCION` varchar(255) default NULL,         
                 `EQUIL3_ARTICULO` blob,                                
                 `EQUIL3_AUTOR` blob,                                   
                 `EQUIL3_601_FECHAASIGNACION` date default NULL,        
                 `EQUIL3_601_FECHA1ERENTREGA` date default NULL,        
                 `EQUIL3_601_FECHARETRO` date default NULL,             
                 `EQUIL3_601_FECHAFINAL` date default NULL,             
                 `EQUIL3_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `EQUIL3_604_PORAVANCE2` int(3) default NULL,           
                 `EQUIL3_604_PORAVANCE3` int(3) default NULL,           
                 `EQUIL3_604_FINALED` varchar(100) default NULL,        
                 `EQUIL3_604_PORAVANCE1` int(3) default NULL,           
                 `EQUIL3_604_FECHAVANCE1` int(3) default NULL,          
                 `EQUIL3_604_DEADLINE` date default NULL,               
                 `EQUIL3_604_FECHAFINAL` date default NULL,             
                 `EQUIL3_605_PORAVANCE1` int(3) default NULL,           
                 `EQUIL3_605_FECHAAVANCE1` date default NULL,           
                 `EQUIL3_605_FINALDISENO` date default NULL,            
                 `EQUIL3_605_FECHAFINAL` date default NULL,             
                 `EQUIL3_605_PORAVANCE1AN` int(3) default NULL,         
                 `EQUIL3_605_FECHAAVANCE1AN` date default NULL,         
                 `EQUIL3_605_DEADLINE` date default NULL,               
                 `EQUIL3_605_FECHAFINALAN` date default NULL,           
                 `EQUIL4_SECCION` varchar(255) default NULL,            
                 `EQUIL4_SUBSECCION` varchar(255) default NULL,         
                 `EQUIL4_ARTICULO` blob,                                
                 `EQUIL4_AUTOR` blob,                                   
                 `EQUIL4_601_FECHAASIGNACION` date default NULL,        
                 `EQUIL4_601_FECHA1ERENTREGA` date default NULL,        
                 `EQUIL4_601_FECHARETRO` date default NULL,             
                 `EQUIL4_601_FECHAFINAL` date default NULL,             
                 `EQUIL4_604_NUMEROPANTALLAS` int(4) default NULL,      
                 `EQUIL4_604_PORAVANCE2` int(3) default NULL,           
                 `EQUIL4_604_PORAVANCE3` int(3) default NULL,           
                 `EQUIL4_604_FINALED` varchar(100) default NULL,        
                 `EQUIL4_604_PORAVANCE1` int(3) default NULL,           
                 `EQUIL4_604_FECHAVANCE1` int(3) default NULL,          
                 `EQUIL4_604_DEADLINE` date default NULL,               
                 `EQUIL4_604_FECHAFINAL` date default NULL,             
                 `EQUIL4_605_PORAVANCE1` int(3) default NULL,           
                 `EQUIL4_605_FECHAAVANCE1` date default NULL,           
                 `EQUIL4_605_FINALDISENO` date default NULL,            
                 `EQUIL4_605_FECHAFINAL` date default NULL,             
                 `EQUIL4_605_PORAVANCE1AN` int(3) default NULL,         
                 `EQUIL4_605_FECHAAVANCE1AN` date default NULL,         
                 `EQUIL4_605_DEADLINE` date default NULL,               
                 `EQUIL4_605_FECHAFINALAN` date default NULL,           
                 `POSTRE1_SECCION` varchar(255) default NULL,           
                 `POSTRE1_SUBSECCION` varchar(255) default NULL,        
                 `POSTRE1_ARTICULO` blob,                               
                 `POSTRE1_AUTOR` blob,                                  
                 `POSTRE1_601_FECHAASIGNACION` date default NULL,       
                 `POSTRE1_601_FECHA1ERENTREGA` date default NULL,       
                 `POSTRE1_601_FECHARETRO` date default NULL,            
                 `POSTRE1_601_FECHAFINAL` date default NULL,            
                 `POSTRE1_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `POSTRE1_604_PORAVANCE2` int(3) default NULL,          
                 `POSTRE1_604_PORAVANCE3` int(3) default NULL,          
                 `POSTRE1_604_FINALED` varchar(100) default NULL,       
                 `POSTRE1_604_PORAVANCE1` int(3) default NULL,          
                 `POSTRE1_604_FECHAVANCE1` int(3) default NULL,         
                 `POSTRE1_604_DEADLINE` date default NULL,              
                 `POSTRE1_604_FECHAFINAL` date default NULL,            
                 `POSTRE1_POSTRE1_605_PORAVANCE1` int(3) default NULL,  
                 `POSTRE1_605_FECHAAVANCE1` date default NULL,          
                 `POSTRE1_605_FINALDISENO` date default NULL,           
                 `POSTRE1_605_FECHAFINAL` date default NULL,            
                 `POSTRE1_605_PORAVANCE1AN` int(3) default NULL,        
                 `POSTRE1_605_FECHAAVANCE1AN` date default NULL,        
                 `POSTRE1_605_DEADLINE` date default NULL,              
                 `POSTRE1_605_FECHAFINALAN` date default NULL,          
                 `POSTRE2_SECCION` varchar(255) default NULL,           
                 `POSTRE2_SUBSECCION` varchar(255) default NULL,        
                 `POSTRE2_ARTICULO` blob,                               
                 `POSTRE2_AUTOR` blob,                                  
                 `POSTRE2_601_FECHAASIGNACION` date default NULL,       
                 `POSTRE2_601_FECHA1ERENTREGA` date default NULL,       
                 `POSTRE2_601_FECHARETRO` date default NULL,            
                 `POSTRE2_601_FECHAFINAL` date default NULL,            
                 `POSTRE2_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `POSTRE2_604_PORAVANCE2` int(3) default NULL,          
                 `POSTRE2_604_PORAVANCE3` int(3) default NULL,          
                 `POSTRE2_604_FINALED` varchar(100) default NULL,       
                 `POSTRE2_604_PORAVANCE1` int(3) default NULL,          
                 `POSTRE2_604_FECHAVANCE1` int(3) default NULL,         
                 `POSTRE2_604_DEADLINE` date default NULL,              
                 `POSTRE2_604_FECHAFINAL` date default NULL,            
                 `POSTRE2_POSTRE1_605_PORAVANCE1` int(3) default NULL,  
                 `POSTRE2_605_FECHAAVANCE1` date default NULL,          
                 `POSTRE2_605_FINALDISENO` date default NULL,           
                 `POSTRE2_605_FECHAFINAL` date default NULL,            
                 `POSTRE2_605_PORAVANCE1AN` int(3) default NULL,        
                 `POSTRE2_605_FECHAAVANCE1AN` date default NULL,        
                 `POSTRE2_605_DEADLINE` date default NULL,              
                 `POSTRE2_605_FECHAFINALAN` date default NULL,          
                 `POSTRE3_SECCION` varchar(255) default NULL,           
                 `POSTRE3_SUBSECCION` varchar(255) default NULL,        
                 `POSTRE3_ARTICULO` blob,                               
                 `POSTRE3_AUTOR` blob,                                  
                 `POSTRE3_601_FECHAASIGNACION` date default NULL,       
                 `POSTRE3_601_FECHA1ERENTREGA` date default NULL,       
                 `POSTRE3_601_FECHARETRO` date default NULL,            
                 `POSTRE3_601_FECHAFINAL` date default NULL,            
                 `POSTRE3_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `POSTRE3_604_PORAVANCE2` int(3) default NULL,          
                 `POSTRE3_604_PORAVANCE3` int(3) default NULL,          
                 `POSTRE3_604_FINALED` varchar(100) default NULL,       
                 `POSTRE3_604_PORAVANCE1` int(3) default NULL,          
                 `POSTRE3_604_FECHAVANCE1` int(3) default NULL,         
                 `POSTRE3_604_DEADLINE` date default NULL,              
                 `POSTRE3_604_FECHAFINAL` date default NULL,            
                 `POSTRE3_POSTRE1_605_PORAVANCE1` int(3) default NULL,  
                 `POSTRE3_605_FECHAAVANCE1` date default NULL,          
                 `POSTRE3_605_FINALDISENO` date default NULL,           
                 `POSTRE3_605_FECHAFINAL` date default NULL,            
                 `POSTRE3_605_PORAVANCE1AN` int(3) default NULL,        
                 `POSTRE3_605_FECHAAVANCE1AN` date default NULL,        
                 `POSTRE3_605_DEADLINE` date default NULL,              
                 `POSTRE3_605_FECHAFINALAN` date default NULL,          
                 `POSTRE4_SECCION` varchar(255) default NULL,           
                 `POSTRE4_SUBSECCION` varchar(255) default NULL,        
                 `POSTRE4_ARTICULO` blob,                               
                 `POSTRE4_AUTOR` blob,                                  
                 `POSTRE4_601_FECHAASIGNACION` date default NULL,       
                 `POSTRE4_601_FECHA1ERENTREGA` date default NULL,       
                 `POSTRE4_601_FECHARETRO` date default NULL,            
                 `POSTRE4_601_FECHAFINAL` date default NULL,            
                 `POSTRE4_604_NUMEROPANTALLAS` int(4) default NULL,     
                 `POSTRE4_604_PORAVANCE2` int(3) default NULL,          
                 `POSTRE4_604_PORAVANCE3` int(3) default NULL,          
                 `POSTRE4_604_FINALED` varchar(100) default NULL,       
                 `POSTRE4_604_PORAVANCE1` int(3) default NULL,          
                 `POSTRE4_604_FECHAVANCE1` int(3) default NULL,         
                 `POSTRE4_604_DEADLINE` date default NULL,              
                 `POSTRE4_604_FECHAFINAL` date default NULL,            
                 `POSTRE4_POSTRE1_605_PORAVANCE1` int(3) default NULL,  
                 `POSTRE4_605_FECHAAVANCE1` date default NULL,          
                 `POSTRE4_605_FINALDISENO` date default NULL,           
                 `POSTRE4_605_FECHAFINAL` date default NULL,            
                 `POSTRE4_605_PORAVANCE1AN` int(3) default NULL,        
                 `POSTRE4_605_FECHAAVANCE1AN` date default NULL,        
                 `POSTRE4_605_DEADLINE` date default NULL,              
                 `POSTRE4_605_FECHAFINALAN` date default NULL,          
                 PRIMARY KEY  (`ID`)                                    
               ) ENGINE=InnoDB DEFAULT CHARSET=latin1
maybe that would help so someone can help me, please, im kind of desperate


feyd | Please use[/syntax]

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Tue Jun 13, 2006 10:24 am
by pedrotuga
You should AT LEAST put ARTICO, AGORA, etc etc in separate tables, one table for each. Then yo use a foreigner key to join the multiple tables.

This is the very basic of database design. If you dont understand what am i talking about i strongly recomend you take a day reading about database basics... it doesnt take more than that to know the basics

Posted: Tue Jun 13, 2006 11:20 am
by GM
alexislalas wrote:to get an idea, this is how my database looks like:

Code: Select all

CREATE TABLE `esqueleto_eda` (                           
                 `ID` int(11) NOT NULL auto_increment,                  
                 `NUMERO_REVISTA` int(10) default NULL,                 
                 `MES_PUBLICACION` varchar(100) default NULL,           
                 ...
                 ...
                 `POSTRE4_605_DEADLINE` date default NULL,              
                 `POSTRE4_605_FECHAFINALAN` date default NULL,          
                 PRIMARY KEY  (`ID`)                                    
               ) ENGINE=InnoDB DEFAULT CHARSET=latin1
maybe that would help so someone can help me, please, im kind of desperate :?
I agree with pedrotuga.

The whole idea behind a relational database (like mySQL) is that you have various tables which are related.

For instance, I have some data about Magazines, and I have some data about Articles.

Data about Magazines consists of MAGAZINE_ID, MAGAZINE_NAME, MAGAZINE_DATE
Data about Articles consists of ARTICLE_ID, MAGAZINE_ID, AUTHOR

Here I create (at least) 2 tables: one for Magazines (which I'll call T_MAGAZINE) and one for Articles (which I'll call T_ARTICLE). They will look like this:

Code: Select all

CREATE TABLE T_MAGAZINE (
MAGAZINE_ID int(6) not null auto_increment,
MAGAZINE_NAME varchar(50) not null,
MAGAZINE_DATE timestamp,
PRIMARY KEY (MAGAZINE_ID));

CREATE TABLE T_ARTICLE (
ARTICLE_ID int(8) not null auto_increment,
MAGAZINE_ID int(6) not null,
AUTHOR varchar(50) not null,
PRIMARY KEY (ARTICLE_ID));
Notice how in the articles table, the field MAGAZINE_ID refers to the unique ID of the magazine? In this way, if I'm looking for a particular Article, I automatically know whaich magazine it was in. I also know for each magazine which articles are contained, and I can also search by author.

Note, it would also be good practice to put the magazine names into a separate table, each with their own ID, to avoid duplication of data in the Magazines table.

These things really are quite basic - you need to find a beginners guide to SQL.

feyd | psst, [syntax] uses double quotes ;)[/syntax]

Posted: Tue Jun 13, 2006 11:47 am
by alexislalas
thanks guys, and sorry for my wrong posting feyd.



ill change my database tables. but theres still one more thing that concerns and troubles me.

how do i insert each row (of the image shown above) in the table.

i would have a table for each "section" with:
ID
SUBSECCION
ARTICULO
AUTOR
FECHA1
FECHA2
FECHA3
FECHA4


but i have 3-4 rows to fill at the same time, how do i make each row a new record in the table?



sorry for all my neewbie questions :oops:

Posted: Mon Jun 19, 2006 12:16 pm
by alexislalas
anyone?