Searching MySQL with AND / OR Functions

[duartec]

Hello!

Does anyboydy can help me? i need to create an interface in php that can search (AND / OR) into mysql db.

Thanks
duarte

[crististoica]

In your select query you can add conditions, like this:
"select {field name 1, fild name 2, ...} from {table name} where {condition}"
"condition" is a statement like this:
" {field name 1} = {field value}"
You can use also <, >, <=, >=, like etc.
And this is what you need:
"condition" can be made from more conditions:
"condition" = {condition 1} and {condition 2}"
ro
"condition" = {condition 1 } or {condition 2}".
Good luck!

[duartec]

Thanks Cristi. But my problem is a little more especific. Imagine a db with articles from a newspapper, what i need to do is to create an interface that can something like this:

Search Food and Health
Search Animal or Vegetal

The interface should be able to do both querys.

Can you help me?

[crististoica]

First, You must get the searched string from the textfield, with
<? $var = $HYYP_POST_VARS["textfieldname"];
?>
Then, split $var into an array (for example):
<? $arSplit = explode(" ", $var); ?>
Now, verify if every $arSplit[$i] is 'AND', 'OR', 'NOT':
<? $blnAND = strcasecmp($srSplit, 'AND'); ?>
and create the appropriate query, for example:
<?
$sSQL = SELECTarticle, keyword FROM MyNewspaper
WHERE keyword = 'Animal'
AND keyword = 'Vegetal';
?>
Read the string functions in the PHP Manual, and something about SQL, and test in MySQL every query You make.