Continuing on from this I now have a problem with the SQL
PHP MySql
I have three recordsets on the page (all created through DW server behaviours)
The aim is to have a list of people to choose from (see above) but exclude those that appear in another list.
So the first recordset gains it's ID from a previous page and the ID is given through a URL parameter "../add_to_list/add_member_to_list.php?listID= ) This gives the result of "95" in my testing instance.
Recordset name = rsList
SELECT id, name
FROM bbc_lists
WHERE id = colname
colname=
integer -1
runtime value = $_GET['listID']
This is tested and works.
The second recordset takes that ID and lists all the people who are already in it
Recordset name = rsListMembers
SELECT person_id, list_id, id
FROM bbc_listmembers
WHERE list_id = colname
colname =
integer -1
runtime value= $row_rsList['id']
tested and works.
The third recordset is the one that is proving troublesome. It is supposed to list the people (which it does) but not those that appear in the second recordset
Recordset name = rsPeople
SELECT id, firstname, lastname, realmail
FROM bbc_people
WHERE id <> colname
ORDER BY lastname ASC
colname =
integer -1
runtime value = $row_rsListMembers['person_id']
The rsListMembers recordset returns two "people" (in my testing scenario)
The result of running the third recorset is that the first person to appear in the list is omitted (correctly) but the second person remains. So it would appear that it doesn't "run through" the table to get to the second name. It stops after reaching the first one.
I'm sure it's something simple but it baffles me.
Any help, as always, most appreciated.
