Why doesnt this pick up the $dbfirstnamr var?

Coding Error?

[OpalRec]

$DBFirstName = (string) trim($_POST[FirstName]);
$DBLastName = (string) trim($_POST[LastName]);
$DBEmail = (string) trim($_POST[Email]);

$query="SELECT * FROM cdata WHERE FirstName='$DBFirstName' || LastName='$DBLastName' || Email='$DBEmail'" ;

$result = mysql_query($query) or die(mysql_error());

The above code snipit works when Lastname or Email exist in the DBm but not with Firstname. Any ideas anyone?

[Matthew1980]

Hi there OpalRec,

Welcome to WebmasterWorld!

Your code:-

//typecasting not needed as default type from form is string...
//need to have the quotes there too - else assumed constant - error_reporting(E_ALL) would detect //that

$DBFirstName = trim(strip_tags($_POST['FirstName']));
$DBLastName = trim(strip_tags($_POST['LastName']));
$DBEmail = trim(strip_tags($_POST['Email']));

$query = "SELECT * FROM `cdata` WHERE `FirstName` = '".$DBFirstName."' or `LastName` = '".$DBLastName."' or `Email` = '".$DBEmail."' ";

$result = mysql_query($query) or die(mysql_error());

Check your data getting through, ensure that your vars are populated as expected, then carry on.

Cheers,
MRb

[OpalRec]

Thanks MRb

That solved the problem. I only started teaching myself PHP 2 weeks ago, so expect a few more Newbie questions.

[Matthew1980]

Cool! Glad that it did the job, we all have to start somewhere don't we :)

Enjoy the learning curve.

Cheers,
MRb