[Heaven Knows]

Originally Posted by kh99

I was assuming that you know how to query the database to see if the field is unique, but if not we could help you with that as well.

in "register" templates i added the following function to test

function checkdisplayname(displayname)
{
if(displayname.value == '')
{
alert('Blank Display Name');
return false;
}
else
{
return true;
}
return false;
}

and inside the function verify_passwords i add the function above to force it check for valid display name when i click the button to finish registering


function verify_passwords(password1, password2)
{
// do various checks, this will save people noticing mistakes on next page

if (!checkdisplayname(cfield_5))
{
return false;
}

...................

.......



I work ok

now i want the function "checkdisplayname" will check for the unique value in mysql database. Can you help me to call the result from an external php or how to query mysql from a template by editting the function above

THanks and regards