• We've upgraded our forums. Please post any issues/requests in this thread.

Search results

  1. Akumos

    my CPU is dead... what next?

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

    my CPU is dead... what next?

    my mistake, 3GB version! :laugh:
  3. Akumos

    my CPU is dead... what next?

    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...
  4. Akumos

    MySql SELECT statement help please

    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 :)
  5. Akumos

    MySql SELECT statement help please

    awesome :) working perfectly.. thank you!
  6. Akumos

    MySql SELECT statement help please

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

    MySql SELECT statement help please

    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.
  8. Akumos

    MySql SELECT statement help please

    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!
  9. Akumos

    MySql SELECT statement help please

    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!
  10. Akumos

    MySql SELECT statement help please

    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";
  11. Akumos

    MySql SELECT statement help please

    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!
  12. Akumos

    MySql SELECT statement help please

    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.
  13. Akumos

    MySql SELECT statement help please

    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!
  14. Akumos

    MySql SELECT statement help please

    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...
  15. Akumos

    Is there an easy way to do this in Excel?

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

    5x HP 4GB PC3L-10600R-R ECC Ram

    Looking to sell. Free first class P&P to the UK. Brand new and sealed, £40 a stick. Thanks.
  17. Akumos

    Is there an easy way to do this in Excel?

    Thanks for the reply. This is how the data is exported. Is there a way to get the pay in a new column automatically?
  18. Akumos

    Is there an easy way to do this in Excel?

    Thanks.. will look into it.. Any more info on the removing blank rows after getting the totals would be great :)
  19. Akumos

    Is there an easy way to do this in Excel?

    Hi All I have an excel sheet and wondered if there was an easy way to achive this: The left column has employee numbers, the right column lists pay. Sometimes, an employee has more than one pay, so it lists directly underneath (without displaying the employee number again). I want the pays for...
  20. Akumos

    Access help please..

    Hi I'm wondering if you can make a form have an expand button on records to show linked information from another table to that record? The same was it does already on the table view. It uses a little plus icon at the start of each record in the table view: Thanks for taking the time to read :)
  21. Akumos

    Help me set up home FTP server? :)

    Thanks for the advice, got that. Needed a user setup on Filezilla.
  22. Akumos

    Help me set up home FTP server? :)

    Hey.. I've just registered a domain name with 123-reg.. added a DNS A record for ftp to point to my public IP. MXToolbox shows it has updated. I've installed filezilla server on my PC, set it to listen on port 21. I've forwarded the port on my router to my PCs IP address... What else do I need...
  23. Akumos

    Update statement to a maximum of 100.. SQL

    Thanks, sorted! - It was interesting reading your opinions of PHPMyAdmin too :)
  24. Akumos

    Update statement to a maximum of 100.. SQL

    lol - but it's simple and makes everything look pretty :)
  25. Akumos

    Update statement to a maximum of 100.. SQL

    Update: I just found the CHECK constraint, which would work perfectly but I am using PHPMyAdmin so mySQL doesn't support I don't think.. is there any other way to implement this?