Select statement with && to combine results?

[stevew]

I have simplified my radio button request below:

 

<form name="myform" action="apple.php">

<input type="radio" name="apple" value="apple"> apple<br>

<input type="submit" value="submit" name="submit">

</form>

 

<form name="myform" action="banana.php" method="POST">

<input type="radio" name="banana" value="banana"> banana<br>

<input type="submit" value="submit" name="submit">

</form>

 

output for apple.php

$result = mysql_query("SELECT * FROM tbl WHERE apple LIKE 'yes%' ")

 

output for banana.php

$result = mysql_query("SELECT * FROM tbl WHERE banana LIKE 'yes%' ")

 

How can I create an apple-banana.php ?

$result = mysql_query("SELECT * FROM tbl WHERE apple && banana LIKE 'yes%' ")

 

thanks.

[jcbones]

$result = mysql_query("SELECT * FROM tbl WHERE apple LIKE 'yes%' AND banana LIKE 'yes%' ") 

[hakimserwa]

this should help you

$result = mysql_query("SELECT * FROM tbl WHERE banana LIKE ='yes%' AND banana LIKE = 'yes%' ");

[stevew]

Awesome...thanks for the help.

[Pikachu2000]

this should help you

$result = mysql_query("SELECT * FROM tbl WHERE banana LIKE ='yes%' AND banana LIKE = 'yes%' ");

 

That has the same comparison twice. Why?

[hakimserwa]

this should help you

$result = mysql_query("SELECT * FROM tbl WHERE banana LIKE ='yes%' AND banana LIKE = 'yes%' ");

 

That has the same comparison twice. Why?

 

I think thats what he wants, he wan t to into the table an d look for apples and bananas that have a value of yes.

[stevew]

I will try all of the examples

 

thanks.

[Pikachu2000]

this should help you

$result = mysql_query("SELECT * FROM tbl WHERE banana LIKE ='yes%' AND banana LIKE = 'yes%' ");

 

 

That has the same comparison twice. Why?

 

I think thats what he wants, he wan t to into the table an d look for apples and bananas that have a value of yes.

 

You should probably read your query string again. It has the same comparison twice, and the syntax is wrong. LIKE doesn't use an equality comparison '='.

[hakimserwa]

this should help you

$result = mysql_query("SELECT * FROM tbl WHERE banana LIKE ='yes%' AND banana LIKE = 'yes%' ");

 

 

That has the same comparison twice. Why?

 

I think thats what he wants, he wan t to into the table an d look for apples and bananas that have a value of yes.

 

You should probably read your query string again. It has the same comparison twice, and the syntax is wrong. LIKE doesn't use an equality comparison '='.

 

hahahah pikachu sorry men  ment

$result = mysql_query("SELECT * FROM tbl WHERE apple LIKE ='yes%' AND banana LIKE = 'yes%' ");

[jcbones]

Or, you could just go back up to mine, because that is still wrong. 

 //wrong
banana LIKE = 'yes%';
//right
banana LIKE 'yes%';