Microsoft Word - Sam's Teach Yourself MySQL in 21 Days - SAMS.doc

$errmsg = "

Field 'Password' must be filled in.

if ($Password eq "") {

$message = $message.$errmsg ;

$found_err = 1 ; }

if ($found_err) {

&PrintError; }

Start Building the SQL string

$SQL = "SELECT * FROM Customers as C, Ads as A

WHERE A.Customer_ID = C.Customer_ID ";

$Build = "AND C.Gender = 'M' ";

if ($Gender eq "M"){

$SQL = $SQL.$Build;}

$Build = "AND C.Gender = 'F' ";

if ($Gender eq "F"){

$SQL = $SQL.$Build;}

$Build = "AND C.Age >= $LAge AND C.Age <= $UAge ";

$SQL = $SQL.$Build;

$Build = "AND C.Hair_Color ='$Hair' ";

if ($Hair){

$SQL = $SQL.$Build;}