Re: Return values from a select

[Michael Smith]

I have now changed the code as below:

$sql = "SELECT lotno, fname, lname, address1, phone1, email FROM customer1 WHERE trim(lotno) = '400' " ;

$result = $conn->query($sql);

if ($result->num_rows > 0){
$FirstName = $_POST["fname"];
$Lastname = $_post["lname"];
echo "First Name " . $FirstName;
echo "Last Name " . $LastName;
}
else {
echo "No record found at all.";
}

So the return values are from the Table Customer1. But I get error messages about the code: $FirstName = $_POST["fname"];

Mike