Using IF and Else Statement

[jaldod]

I wanted to make a search engine for my e-library and i had 3 fields that if the user submit one of them or 2 of them or all 3 off them,it will do a correct query..

I already try to do this but when just one of the filed is blank ex. author, i get an error..

I had 3 fields :
1. Keyword
2. File Name
3. Author

<?php
$sql	 ="SELECT * "; 
$sql	.="FROM tbl_keyword "; 
$sql	.="WHERE ";

if ($keyword != "")
	{
	$sql  .="keyword LIKE '%$keyword%'";
	}
if ($author != "")
	{
	$sql .=" OR author LIKE '%$author%'";
	}
if ($namefile != "")
	{
	$sql .=" OR namefile LIKE '%$namefile%'";
	}

if ($keyword == "" && $author == "" && $namefile == "")
	{
	header("Location: index.php");
 	exit ();	
	}
?>

I wanted to know how should i do this or is there a simple coding for it..could anybody help me please :-)

thanks be 4.

[Hafkas]

This may work for you.

<?php 
$sql = "SELECT * FROM tbl_keyword WHERE"; 

if ($keyword != "") { 
    $sql = $sql." keyword LIKE '%$keyword%'"; 
} 

if ($author != "") { 
         if ($keyword != "") {
             $sql = $sql." OR";
         }

$sql = $sql." author LIKE '%$author%'"; 
} 

if ($namefile != "") { 
         if ($keyword != "" || $author != "") {
             $sql = $sql." OR";
         }

$sql .=" namefile LIKE '%$namefile%'"; 
} 

if ($keyword == "" && $author == "" && $namefile == "") 
    { 
    header("Location: index.php"); 
    exit ();     

    } 
?> 

[jaldod]

<?
include('search.conf.php');

$sql	 ="SELECT * "; 
$sql	.="FROM tbl_search "; 
$sql	.="WHERE ";

if ($keyword != "") {  

    $sql = $sql." keyword LIKE '%$keyword%'";  

}  

if ($author != "") {  

         if ($keyword != "") { 
             $sql = $sql." OR"; 
         } 

$sql = $sql." author LIKE '%$author%'";  
}  

if ($namefile != "") {  

         if ($keyword != "" || $author != "") { 
             $sql = $sql." OR"; 
         } 

$sql .=" namefile LIKE '%$namefile%'";  
}  

if ($keyword == "" && $author == "" && $namefile == "")  

    {  

    header("Location: index.php");  

    exit ();      

    }  


$query=mysql_query ($sql);
while($record=mysql_fetch_row($query))
	{
	echo "<b>Keyword    :</b> $record[1]<br>";
	echo "<b>Author     :</b> $record[4]<br>";
	echo "<b>Name file  :</b> <a href='files/$record[2]'>$record[2]</a><br><br>";
	}
?>

when i click on the submit button and dont insert any data in any fields i get an error :

Warning: Cannot add header information - headers already sent by (output started at c:\apache\htdocs\search\search.conf.php:13) in c:\apache\htdocs\search\search_p.php on line 30

[jaldod]

is there any problems with my script ? :o)

[procoder]

That means somethign already sent something to the server before the header function.

Like an echo or a error message

c:\apache\htdocs\search\search.conf.php:13)

means that script, line 13