Continuing on from this I now have a problem with the SQL
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
WHERE id = colname
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
WHERE list_id = colname
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
WHERE id <> colname
ORDER BY lastname ASC
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.