Salut am 4 tabele
destinatie(adica un fel de statistica)
telefon
user
cdr
si am facut un join care sa fac legaturi intre 3 tabele (destinatie,telefon si user)si folosesc INSERT INTO SELECT la al patrulea tabel(cdr) pentru a adauga toate informatiile de la tabela destinatie care are statisticile + username-ul si id-ul userului , problema e ca insereaza doar primul rand
$myDb->connect();
$result = mysql_query("SELECT * FROM cdr WHERE username='$user' ");
if(mysql_num_rows($result) ==0) {
$queryss = "Insert into cdr(data_aper,termination,destinatar,durata,telefon,username,bani,id)
select data_aper,termination,destinatie.destinatar,durata,destinatie.telefon, yob_users.username,(sum(destinatie.durata)/60)*0.00275 as bani,yob_users.id
FROM ((telefon
INNER JOIN yob_users ON telefon.id = yob_users.id)
INNER JOIN destinatie ON telefon.telefon = destinatie.telefon)
WHERE username='$user'
";
mysql_query($queryss) or die(mysql_error());
} else {
echo "nuuuu";
}
$myDb->close();
Ma ajuta cineva cu un insert ?
Moderators: Moderatori ajutatori, Moderatori
- sergiu4995
- Membru eXtream
- Posts: 2052
- Joined: 08 Oct 2011, 21:05
- Detinator Steam: Da
- Has thanked: 31 times
- Been thanked: 17 times
- Contact:
-
- Membru, skill 0
- Posts: 54
- Joined: 13 Nov 2018, 11:24
- Detinator Steam: Nu
- CS Status: Citesc forumul eXtreamCS.com...!
- Fond eXtream: 0
- Contact:
Ai primary key la fiecare tabel?
Code: Select all
INSERT INTO cdr(data_aper,termination,destinatar,durata,telefon,username,bani,id)
SELECT data_aper,termination,destinatie.destinatar,durata,destinatie.telefon, yob_users.username,(sum(destinatie.durata)/60)*0.00275 as bani,yob_users.id
FROM telefon
INNER JOIN yob_users ON telefon.id = yob_users.id
INNER JOIN destinatie ON telefon.telefon = destinatie.telefon
WHERE username = '$user'
- sergiu4995
- Membru eXtream
- Posts: 2052
- Joined: 08 Oct 2011, 21:05
- Detinator Steam: Da
- Has thanked: 31 times
- Been thanked: 17 times
- Contact:
doar tabela destinatie nu are pentru ca datele sunt introduse prin importarea fisierului csv si de asta am facut join ca apoi sa inserez datele selectate in tabelul cdrKarma//goddess wrote:Ai primary key la fiecare tabel?
Code: Select all
INSERT INTO cdr(data_aper,termination,destinatar,durata,telefon,username,bani,id) SELECT data_aper,termination,destinatie.destinatar,durata,destinatie.telefon, yob_users.username,(sum(destinatie.durata)/60)*0.00275 as bani,yob_users.id FROM telefon INNER JOIN yob_users ON telefon.id = yob_users.id INNER JOIN destinatie ON telefon.telefon = destinatie.telefon WHERE username = '$user'
Am reusit, am avut acolo la select din join la acea mica functie sum si am scos-o, acum imi insereaza datele,dar acum sa verific daca la tabela destinatie daca mai fac un import cu noi date sa vad sa nu apara vreo coleziune, nu dati tc
-
- Information
-
Who is online
Users browsing this forum: Bing [Bot], Coka Cola, GENERALU', Semrush [Bot], SoLoz0rNNN, Traficant De Wi-Fi, trekA and 320 guests