nipplesalad

Hello, i am trying to create an SQL query for my processmaker process and im stuck on deleting multiple entries. I have two tables; PMT_COURSEINPLAN and PMT_PLAN PMT_PLAN has two fields: ID (The ID of the student) PLANID (The ID of the plan) PMT_COURSEINPLAN also has two fields: COURSE (The ID of the course) PLANID (The ID of the plan) I also have a variable called $student which is the current student using the system I need a query that does the following: When a student is accepted, they need to create an educational plan with courses in it When the query is done, there should be no entries in PMT_COURSEINPLAN that have the same PLANID as a plan that is in PMT_PLAN that has a ID that is the same as the student id ($student) of the student using the system I realize this may not make sense so i will add some screenshots of my database that should help understand my problem. https://ibb.co/RChNKWw https://ibb.co/R3sywjf https://ibb.co/NCjst7k https://ibb.co/bWbbWvW https://ibb.co/q1CTbW9 https://ibb.co/HxQvYnk Since i am using processmaker, a query would look like this: $approved = @@check_student[0]; $student = @@student; if ($approved == 1) { $query = "DELETE FROM PMT_PLAN WHERE ID = $student;"; @@test = $query; executeQuery($query); } This query removes an old plan if a student is accepted and thus makes a new one I know how to create a one to many query, i just dont know how to make a delete one... A one to many query would look like this in processmaker SELECT c.ID AS k, c.NAME AS v FROM PMT_COURSE AS c, PMT_COURSEINPLAN AS p, PMT_PLAN as m WHERE c.ID = p.COURSE AND p.PLANID = m.PLANID AND m.ID = '@=student' This query shows all the courses from the (current user) students educational plan I believe processmaker uses a custom SQL called PMQL but since there is no flair for that i am going to flair this as MySQL, sorry! Thank you for your help!

Hello everyone My pc has frequent BSOD's and they happen mostly when i boot up my pc and sometimes when i shut it down. It happens about every 2 days and its bothering me alot. I've got alot of BSOD's messages that are memory related like MEMORY MANAGEMENT of PAGED FAULT IN NON PAGED AREA. Because i've been told these are memory issues i've run the windows memory scanner and memtest86, they both show no issues. I've also switched my ram sticks around and it didn't fix my issue. I've done SFC scannow and some other automatic repair things but nothing works. When viewing the minidump in BlueScreenView it says its caused by driver ntoskrnl.exe and address ntoskrnl.exe+3f6c20 Here is a minidump of the most recent BSOD (onedrive): https://1drv.ms/u/s!AnCV9r6SGqrYjmA3vUuioMEXaqpt Here are some more dumps: https://1drv.ms/u/s!AnCV9r6SGqrYjl-uvK2ZNNvhpowD https://1drv.ms/u/s!AnCV9r6SGqrYjl4l19fbQlM6wXwT https://1drv.ms/u/s!AnCV9r6SGqrYjl1SNGWpoLf0GaZl Thank you!

Its a nice bonus, i was already looking at the G502 doom eternal is just a bonus, i dont really care for it

Hello everyone I need to choose what mousse i buy today because of a sale and i cant decide which one Im struggling to choose between the g502 hero and the g703 hero. They are both 60$ and the g502 comes with doom eternal and the g703 is just on sale. Currently i have the G403 which i love but i have issues with the scrollwheel and the sides are getting sticky and letting go. I heard some people complain about the same issues on the g703 but i dont know if these issues are still a thing. I like the weight and shape of the g403 so the g703 would be the logical choice but i dont want the same issues as the ones i have now on my g403. What do you guys think? Thanks for reading!

Hello everyone I'm looking for wireless earbuds but i can't really decide if 100 euros for the Galaxy Buds Plus is worth it. I plan to use bluetooth earbuds in the gym, at school and maybe at work. Are the Galaxy Buds Plus worth the 100 euros if other wireless earbuds like the QCY T5 or the SOUNDPEATS truedots are also an option for around 20-30 dollars? (I'm also using a Samsung phone) Thank you for your time!

I only have the GPU in right now and plan on buying the rest on christmas, basicly what you are saying is that the extra performance isn't worth the potential issues it could give? (correct me if im wrong )

But are the driver's any good now? I've seen alot of people have issues with them.

I play on 1080p 144hz (i also have a 1080p 60hz 2nd monitor) and i don't plan on streaming/recording but having the option would be nice. If i wanted the RTX 2060 Super Gaming x i would've paid €50 more which didn't seem worth it to me

Hey guys Im putting together a new pc and for the GPU i decided on the RTX 2060 Super because i heard some bad stories about the RX 5700XT's drivers. Now im second guessing my decision, and i want to know what you guys think (i have bought the RTX 2060 Super but can still return it). I previously decided on the RTX 2060 Super because: - good drivers (I've had my fair share of buggy amd drivers) - cool and quiet - good performance Do you guys think i should return it for an RX 5700XT? The prices are: - MSI RTX 2060 Super Armor OC (€370) - MSI RX 5700XT Gaming X (€410) Thanks alot!

I'll do that actually! Im also debating upgrading the SSD from the BX500 240GB to the MX500 500GB for a little more than double the price, what do you think about that?

Ill keep that in mind, thanks for your reply!

Im planning on using the BX500 as a boot drive and have a 1TB HDD for my games, would that work or is it worth it to spend more for the OS Primary drives listed here? Thanks for your help!

Do you think an Kingston A2000 250GB NVMe is better for 10 bucks more?

I will, i very much dont mind paying 5 bucks more for that, thanks for the save!

I haven't, is the Crucial so much faster? I thought it was only like a 10MB/s diffrence

What do you think about the corsair TX550M V2?

Yes, thats the one!

Thanks for the help!

PCPartPicker: PCPartPicker Part List Type Item Price CPU AMD Ryzen 5 3600 3.6 GHz 6-Core Processor €195.05 @ Azerty Motherboard MSI B450 TOMAHAWK MAX ATX AM4 Motherboard €117.00 @ CD-ROM-LAND Memory Corsair Vengeance LPX 16 GB (2 x 8 GB) DDR4-3200 Memory €68.50 @ Azerty Storage Kingston A400 240 GB 2.5" Solid State Drive €29.95 @ Azerty Storage Western Digital Caviar Blue 1 TB 3.5" 7200RPM Internal Hard Drive €38.99 @ Azerty Video Card MSI GeForce RTX 2060 SUPER 8 GB ARMOR OC Video Card €463.95 @ CD-ROM-LAND Prices include shipping, taxes, rebates, and discounts Total €913.44 Generated by PCPartPicker 2019-12-16 18:03 CET+0100 the GPU link: https://www.msi.com/Graphics-card/GeForce-RTX-2060-SUPER-ARMOR-OC/Specification

Thanks for your reply! PC partpicker says its about 350W, the GPU website says it needs a minimum of 550W

Hey guys Im thinking about purchasing a rtx 2060 super (the armor oc version from MSI) and it says it recommends a PSU with a minimum of 550W. I wanted to buy a 500W be quiet! PSU but do i actually need to buy a 550W PSU? The total power draw of my system will be around 350W. Thank you!

I've heard alot of bad stories about the drivers on that card, are they better now? I've already had my fair share of bad amd drivers so i wouldn't mind sacrificing performance for stability. Also my current AMD GPU probably became instable because of it's high temperatures and i don't want that to happen again...

Hey guys My current pc has a instable graphics card of some sort and im not sure if i should just buy a new GPU or build an entirely new PC. Here are my current specs: - i5 4460 (cpu) - Gelid Solutions Tranquillo rev. 2 (cpu cooler) - MSI B85-G41 PC Mate (motherboard) - 8gb DDR3 ram 1600mhz (ram) - r9 380 2gb (gpu) - 1TB HDD - Seasonic 430W bronze PSU What i would want to build if i where to build a new pc: - AMD Ryzen 5 3600 Boxed (cpu) - Gigabyte B450 Aorus Elite (motherboard) - MSI GeForce RTX 2060 Super Armor OC (gpu) - Seagate Barracuda, 1TB (hdd) - Fractal Design Define R5 Black (case) - Gelid Solutions Phantom Black (cpu cooler) - Corsair Vengeance LPX CMK16GX4M2B3200C16 (RAM, 16GB at 3200mhz) - Corsair TX550M V2 (psu) - Kingston A2000 250GB (m.2 ssd) This build is around 1000 euro's Do you think i should just buy a new GPU or a new PC? Also feel free to drop some recommendations for the build Thanks a ton!

Thanks for the help man!

I'll try that, thank you!