php help, if

[roxiroxi]

hi,

I've got a problem here, can anyone help me?

$hostName = "localhost";
$userName = "root";
$password = "password";
$dbName = "dvdswap";

$title = $_POST['title'];
$option = $_POST['option'];

       
// make connection to database
mysql_connect($hostName, $userName, $password) or die("Unable to connect to host $hostName");

mysql_select_db($dbName) or die( "Unable to select database $dbName");

if ($_POST['option'] == "exactly")
{
$query = "SELECT product.prodid, product.title, product.pyear, product.format, product.cert, product.userid
        FROM product where product.title = '$title'";
}

else ($_POST['option'] == "starts") {
$query = "SELECT product.prodid, product.title, product.pyear, product.format, product.cert, product.userid
        FROM product where product.title like '$title%'";
}

else ($_POST['option'] == "includes") {
$query = "SELECT product.prodid, product.title, product.pyear, product.format, product.cert, product.userid
        FROM product where product.title like '%$title%'";
}

[Cagecrawler]

Whats the problem?

[roxiroxi]

the problem is that i get a white page, i know the error is there coz when i dont use the if statements, with one sql query, i get the info

[Cagecrawler]

Couple of things:
echo $_POST['option'] to see what you get.

If you get the right thing, try this switch code instead of the ifs.:

[code]switch ($_POST['option']){
case "exactly":
$query = "SELECT product.prodid, product.title, product.pyear, product.format, product.cert, product.userid FROM product where product.title = '$title'";
break;

case "starts":
$query = "SELECT product.prodid, product.title, product.pyear, product.format, product.cert, product.userid FROM product where product.title like '$title%'";
break;

case "includes":
$query = "SELECT product.prodid, product.title, product.pyear, product.format, product.cert, product.userid FROM product where product.title like '%$title%'";
break;
}[/code]

[roxiroxi]

Thank you for everything it is working!