goleh1995

mysql_query('CREATE TEMPORARY TABLE tmptable SELECT * FROM zr_zinojumi WHERE RZNM_ID='.$messageId.';'); mysql_query('UPDATE tmptable SET RZNM_RPRJ_ID='.$izv.', RZNM_ID='.$id.' WHERE RZNM_ID='.$messageId.';'); mysql_query('INSERT INTO zr_zinojumi(`RZNM_ID`,`RZNM_IDENTIFIKATORS`,RZNM_KRFK_ZIN_VEIDS,RZNM_KRFK_PRIORITAT,RZNM_KRFK_SNIEG_VEIDS,RZNM_KRFK_SMAGUMS,RZNM_ISS_APRAKSTS,RZNM_APRAKSTS,RZNM_NUMURS,RZNM_SASK_DATUMS,RZNM_PLAN_IZP_DATUMS,RZNM_PRASIBA,RZNM_NOVERTEJUMS_STUNDAS,RZNM_RPRJ_ID,RZNM_RZNM_ID_DUBLICE,RZNM_RZNM_ID_AIZVER,RZNM_RKLN_ID,RZNM_RVNM_ID,RZNM_RVVR_ID,RZNM_RVVR_ID_JAIEVIES,RZNM_RVVR_ID_IEVIESTS,RZNM_RLTT_ID_INS,RZNM_RLTT_ID_UPD,RZNM_DATUMS_INS,RZNM_DATUMS_UPD,RZNM_KSTV_KODS) SELECT RZNM_ID, RZNM_IDENTIFIKATORS, RZNM_KRFK_ZIN_VEIDS, RZNM_KRFK_PRIORITAT, RZNM_KRFK_SNIEG_VEIDS, RZNM_KRFK_SMAGUMS, RZNM_ISS_APRAKSTS, RZNM_APRAKSTS, RZNM_NUMURS, RZNM_SASK_DATUMS, RZNM_PLAN_IZP_DATUMS, RZNM_PRASIBA, RZNM_NOVERTEJUMS_STUNDAS, RZNM_RPRJ_ID, RZNM_RZNM_ID_DUBLICE, RZNM_RZNM_ID_AIZVER, RZNM_RKLN_ID, RZNM_RVNM_ID, RZNM_RVVR_ID, RZNM_RVVR_ID_JAIEVIES, RZNM_RVVR_ID_IEVIESTS, RZNM_RLTT_ID_INS, RZNM_RLTT_ID_UPD, RZNM_DATUMS_INS, RZNM_DATUMS_UPD, RZNM_KSTV_KODS FROM tmptable WHERE RZNM_RPRJ_ID='.$izv.';');

tur vnk dazadi var parvietot, vnk gogleju, okey man tagad ieks phpmyadmion kad parbaudu - strada tnx - bet ieks majaslapas, paradas tads Warning: - Notice: Use of undefined constant RPRJ_ID - assumed 'RPRJ_ID' in D:\WebSites lalalal

CREATE TEMPORARY TABLE tmptable SELECT * FROM zr_zinojumi WHERE RZNM_ID='3594'; UPDATE tmptable SET RZNM_RPRJ_ID='60', RZNM_ID='8000' WHERE RZNM_ID='3594'; select * into zr_zinojumi from tmptable Where RZNM_RPRJ_ID='60' ; te es to ID izmainiju pie UPDATE tagad itka jastarad, bet atkal. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'zr_zinojumi from tmptable Where RZNM_RPRJ_ID = '60' LIMIT 0, 30

mysql_query('SET AUTOCOMMIT=0;'); mysql_query('START TRANSACTION;'); mysql_query('LOCK TABLES zr_zinojumi WRITE, tmptable WRITE;'); mysql_query('CREATE TEMPORARY TABLE tmptable SELECT * FROM zr_zinojumi WHERE RZNM_ID='.$messageId.';'); mysql_query('UPDATE tmptable SET RZNM_RPRJ_ID='.$izv.' WHERE RZNM_ID='.$messageId.';'); mysql_query('INSERT INTO zr_zinojumi SELECT * FROM tmptable WHERE RZNM_ID='.$messageId.';'); mysql_query('DROP TEMPORARY TABLE IF EXIST tmptable;'); mysql_query('UNLOCK TABLES;'); mysql_query('COMMIT;'); Ari nestrada

Uzdevums: Nokopet visu rindu no tabulas un to rindu ielikt taja pasa tabula bet jau ar izmainito vienu laukumu.

bet ka citadi man izdarit to?

Sveiks - varat man ludzu pastastit kas te ir nepareizi un ka izlabot. $query = 'SET AUTOCOMMIT=0; START TRANSACTION; LOCK TABLES zr_zinojumi WRITE, tmptable WRITE; CREATE TEMPORARY TABLE tmptable SELECT * FROM zr_zinojumi WHERE RZNM_ID='.$messageId.'; UPDATE tmptable SET RZNM_RPRJ_ID='.$izv.' WHERE RZNM_ID='.$messageId.'; INSERT INTO zr_zinojumi SELECT * FROM tmptable WHERE RZNM_ID='.$messageId.'; DROP TEMPORARY TABLE IF EXIST tmptable; UNLOCK TABLES; COMMIT; '; mysql_query($query);

Man ir jautajums, priekš kam tas ir vajadzigs? Tas kautko maina?

ja :) :D..

vispar man vajag source.. To dizainu es varu nozagt pats sakartot visu, un admin CP ari varu ,bet http://grafija.lv/#/lv/Plastikata-kartes/Plastikata-kartes-cenas-kalkulators/ sito es prinicpa zinu ka izdarit bet praktiski ne :D , un nezinu ka izdarit to sistemu tipa nosutit uz epastu manu pasutijumu.. vot.. un vispar gribas zinat cik tas maksa..

sorry.. kopiju.

Labdien. Ja kas piedodiet par LV gramatiku :) Tatad man ir tads jautajums, vai ir cilveki kuri var izdarit www.grafija.lv majaslapas kopiju, un cik vini par to gribes.. (Ls). Paldies par uzmanibu:)