Recent content by Akumos

OK thanks, will check ebay and test the CPU elsewhere! (hard to find 1155 motherboards though!)

my mistake, 3GB version! :laugh:

Hi all! For the past 5 years, I've been running a decent rig. It runs around a 3570K. My motherboard broke about 6 months ago and I paid over the odds for a low end, hard to find, 1155 motherboard. It has 16GB of memory and a recently bought GTX 1060 (4GB). Well now my CPU has died! I have...

lol thanks Biggie! i've added startdate and enddate columns in the staff table so I may come back for more help if I can't figure it out :)

awesome :) working perfectly.. thank you!

Thanks CounterZues - this looks promising.. need to test further :)

Thanks for your input! Rave: It just times out, i'm not good enough to manipulate the code to try anything different. Biggie: It returns no data. If someone is willing to jump on my phpmyadmin to take a look, please PM me for the details.

Hi - run in to a problem with this SELECT statement so opening this back up :) It works, but when a second CPD session is added, it only shows people that didn't attend the other session. It should show everyone, because no one has attended. Any ideas? Thanks for taking the time to read and help!

Thanks - but like i said in previous post, all working :) using : $sql = "SELECT a.staffname, b.cpdid FROM staff a LEFT OUTER JOIN staff_cpd b ON a.staffid=b.staffid WHERE b.cpdid IS NULL"; Thanks again!

got it - great! thanks for all the input :) $sql = "SELECT a.staffname, b.cpdid FROM staff a LEFT OUTER JOIN staff_cpd b ON a.staffid=b.staffid WHERE b.cpdid IS NULL";

Doesn't return anything.. This is what I tried: $sql = "SELECT a.staffname, b.cpdid FROM staff a LEFT OUTER JOIN staff_cpd b ON a.staffid=b.staffid WHERE b.cpdid = NULL"; Edit: Ah, I see you need to use IS NULL - let me try!

Thanks. Just swaps the order, so the people who attended appear at the top but then everyone else is listed below. I'm hoping to exclude the people that attended from that list.

Hi - thanks for the reply. Pasted as is, this returns everyone - but it lists the people that did attend at the bottom. If I add: WHERE b.cpdid=1 It returns the people that did attend. Any ideas? Thanks again!

Hi Everyone! Please bear in mind that I'm quite new to his. I'm trying to select everything from a table that doesn't exist.. and I'm not sure if it's possible. I'm making a CPD tacker: I have a CPD table to store each session. I also have a staff table. Then, keep record of what staff...

Awesome.. thanks for that :) Will be useful in the future too.