In un progetto ho due tabelle diverse e cerco aiuto, anche a pagamento, per un codice con la funzione di estrarre i dati dalla tabella "_artiste", campo "inizio lavoro" ed elencarli nella tabella "calcalendar" campo "DateField"(date).
Qui di seguito riporto tutte e due tabelle:
Tabella "_aratiste"
Field Type Collation Attributes Null Default Extra Action
nome varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
cognome varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
nazionalita varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
anno nascita date
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
altezza varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
peso varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
seno varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
vita varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
fianchi varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
www varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
mese foto varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
anno foto varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
figurante di sala varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
giorni settmanali di lavoro varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
luogo varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
inizio lavoro date
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
preferenze luogo lavoro varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
preferenze regione di lavoro varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
luogo,regione di lavoro tassativa varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
vuole lavorare a firenze varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
esperienze di lavoro varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
ID int(11)
No
auto_increment Browse distinct values Change Drop Primary Unique Index Fulltext
email varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
cellulare varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
telefono varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
italiano varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
periodo di lavoro varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
fotka1 varchar(100) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
foto2 varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
foto3 varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
interessata a lavorare al mare varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
interessata a lavorare in entroterra varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
se non eu ha il permesso di lavoro varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
comento varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
ingaggio varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
disponibilita varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
prenotazioni varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
pagamenti varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
arrivo esatto varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
conferma prenotazione varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
sviluppi varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
ingaggio x localita mare varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
picture mediumblob
BINARY Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
thumbnail mediumblob
BINARY Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
condizioni varchar(80) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
picture2 varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
picture4 varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
picture5 varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
picture6 varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
picture3 varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
inglese varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
giorno del inizio lavoro date
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
altre lingue varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
NazionalitaAltro varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
Tabella "calcalendar"
Field Type Collation Attributes Null Default Extra Action
id int(11)
No
auto_increment Browse distinct values Change Drop Primary Unique Index Fulltext
DateField date
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
Description text latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
Theme varchar(200) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
TimeField varchar(15) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
EndTime varchar(15) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
DayEvent int(11)
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
EndDate date
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
Period varchar(255) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
Recurrence int(11)
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
Category int(11)
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
LugoArrivo varchar(50) latin1_swedish_ci
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
DataInizioLavoro date
Yes NULL
Browse distinct values Change Drop Primary Unique Index Fulltext
In stesso progetto ci son anche altre visualizzazioni della tabella "calcalendar", chiamate:
"caldayly", "calweekly", "calmonthyly", "calyearly".
Se il codice in merito non fa automaticamente elencare i dati estatti anche nelle visualizzazzini sorpariportate, avrei bisogno di altri condici che farebbero stesso lavoro, elecanre stessi dati anche nelle diverse visualizzazzini della tabella "calcalendar"
ThanksTabella "calcalendar" Tabella "_artiste"