alitte php mysql help please ;D

[lasse48]

hello i am trying to get a php file to work. i need to have the php file to select field in database and if field (u12) == 3 or more than 3 echo "Have a nice weekend!";

 

thanks for looking hope some one has a answer

 

<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("wars") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM s1units") 
or die(mysql_error());


if ($u12=="3") echo "Have a nice weekend!";

?>

[ignace]

<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("wars") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT ul2 FROM s1units") 
or die(mysql_error());

if (false !== $result) {
    $row = mysql_fetch_assoc($result);
    $ul2 = $row['ul2'];
    if ($u12 >= 3) {
        echo 'Have a nice weekend!';
    } else {
        echo 'Get back to work!';
    }
}

?>

[lasse48]

many thanks i will have a look at it     i net was gone some days , thats why i first answer now