- Joined
- Nov 30, 2008
- Messages
- 555 (0.10/day)
- Location
- Birmingham, England...
Processor | Intel Core 2 Quad Q6600 @ 2.8GHz |
---|---|
Motherboard | Gigabyte X48T-DQ6 |
Cooling | Zalman 9500 LED CPU Cooler |
Memory | 2x 2GB Corsair DDR3 XMS3 DHX - 1600MH/PC3-12800 |
Video Card(s) | Gigabyte HD4870 1GB |
Storage | 2x Seagate 320GB Barracuda (RAID 0) 3x 1TB Samsung F3, 140GB WD Maxtor (10,000rpm) |
Display(s) | 2x 20" LG Flatron L204WS |
Power Supply | Powercool 850W |
Software | Windows 7 Ultimate x64 |
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 attended what course, I have a staff_cpd table which only holds staffid and cpdid IF they attended.
So my statement for everyone who attended works fine:
$sql = "SELECT staffname FROM staff JOIN staff_cpd ON staff.staffid=staff_cpd.staffid WHERE staff_cpd.cpdid=".$_GET["id"];
But I also want to show everyone who didn't attend.
Is this possible?
Thanks for taking the time to read and help.
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 attended what course, I have a staff_cpd table which only holds staffid and cpdid IF they attended.
So my statement for everyone who attended works fine:
$sql = "SELECT staffname FROM staff JOIN staff_cpd ON staff.staffid=staff_cpd.staffid WHERE staff_cpd.cpdid=".$_GET["id"];
But I also want to show everyone who didn't attend.
Is this possible?
Thanks for taking the time to read and help.