Mysql Query, comparing values and assigning to PHP variables
function connect() {
$dbname = 'database';
$dbuser = 'username';
$dbpass = 'password';
$dbhost = 'localhost';
mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to database");
}

mysql_select_db(DATABASENAME) or die( "Unable to select database");
$query = "SELECT * FROM `TABLE` WHERE `COLUMN` LIKE 'VAULE'";
$result=mysql_query($query);

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to database");

$query = "SELECT * FROM `TABLE` WHERE `COLUMN` LIKE '%" . $varToCompare . "%'";
$result=mysql_query($query,$conn);

// connection to database
$db = new PDO('mysql:host=localhost;dbname=datadump_pwmgr;charset=UTF-8',
               'datadump_pwmgr',
               'kzddim05xrgl');
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

// setting up prepared statement for the query
$statement = $db->prepare('SELECT * FROM table WHERE column LIKE :value');
$statement->bindParam(':value', $some_variable, PDO::PARAM_STR, 127);

// executing query and fetching first result
if ( $statement->execute())
{
    $data = $statement->fetch(PDO::FETCH_OBJ);
    var_dump( $data );
}

$pdo = new PDO('sqlite::memory:');

$a = new Foo( $pdo );
$b = new Bar( $pdo, 'something');

$count = mysql_num_rows($result);

//if there is more then 1 record retrieved from the database
if($count > 0)
{
    //Do what ever you want to do here, which I think you want to be
    while ($row = mysql_fetch_assoc($result))
    {
        echo $row["Columnname1"];
        echo $row["Columnname2"];
        echo $row["Columnname3"];
    }
}

else
{
    echo "There are no matches for this specific value";
}

$row = 0;
$data = mysql_query("SELECT name1,name2 FROM ....");
while(($result = mysql_fetch_array($data)) !== false)
{
    echo "row = $row, name1 = " . $result["name1"] . ", name2 = " . $result["name2"];
    $row ++;
}

$row = 0;
$data = mysql_query("SELECT name1,name2 FROM ....");
while(($result = mysql_fetch_object($data)) !== false)
{
    echo "row = $row, name1 = $result->name1, name2 = $result->name2";
    $row ++;
}

"SELECT * FROM `TABLE` WHERE `COLUMN` LIKE 'VAULE'" // This will return all rows where column='VAUL'
"SELECT * FROM `TABLE` WHERE `COLUMN` LIKE '%VAULE%'" // This will return all rows where column='%VAUL%' // This will return any row containing 'VAUL' in column
"SELECT * FROM `TABLE` WHERE `COLUMN` LIKE '%VAULE'" // This will return all rows where column='%VAUL' // this will  return all rows ending by VAUL. I guess you get it now :)

$query = "SELECT * FROM `TABLE` WHERE `COLUMN` LIKE '%VAULE%'";
$result=mysql_query($query);

while (false !== ($row = mysql_fetch_assoc($result))) {
    //here $row is an array containing all the data from your mysql row
}

ex: require_once 'dbConnect.php';

<?php
$dbname = 'datadump_pwmgr';
$dbuser = 'datadump_pwmgr';
$dbpass = 'kzddim05xrgl';
$dbhost = 'localhost';
mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to database");
?>