This topic is locked

Checking two fields in add-form

9/30/2007 10:02:33 AM
PHPRunner General questions
D
dossi author

//** Check if specific record exists ****

global $conn;

$strSQLExists = "select * from _members where username='".$userdata["username"]."'";

$rsExists = db_query($strSQLExists,$conn);

$data=db_fetch_array($rsExists);

if($data)

{

echo "Name already in use, choose another username";

return false;

}

else

{

return true;

}
How do this code look, if I want to check two fields?

A
alang 9/30/2007

Something like the following maybe:

[codebox]//** Check if specific record exists ****

global $conn;

$strSQLExists = "select from _members where username='".$userdata["username"]."'";

$rsExists = db_query($strSQLExists,$conn);

$data=db_fetch_array($rsExists);

if($data)

{

echo "Name already in use, choose another username";

return false;

}

else

{

$strSQLExists = "select
from _members where field2='".$userdata["field2"]."'";

$rsExists = db_query($strSQLExists,$conn);

$data=db_fetch_array($rsExists);

if($data)

{

echo "Field2 already in use, choose another Field2";

return false;

}

else

{

return true;

}

}

[/codebox]