I am having a go at this but I can't get it to work.
I have created a recordset "un"
The DB column is "un"
The text field is "username"
SELECT un
FROM users
WHERE un = colname
Colname is;
Name: colname
Type: Test
Default Value: -1
Runtime Value: $_POST['username']
I have then created a "show if recordset not empty" as follows
<?php if ($totalRows_un > 0) { // Show if recordset not empty ?>
Username not recognised
<?php } // Show if recordset not empty ?>
But when I submit the form with an incorrect username nothing happens.
If I change it to "show if recordset is empty" the message shows when the page loads.