[Resolved] alias search value(simple)

hayato1

Sorry i try and try i think i lost my brain somewhere
can anyone help me with this simple stuff.

if a user search value=7 (apple)
show value=13 (rotten apple) as well
only it search for (special case 7) or else 8=8, 9=9, 10=10
i have tried numbers of times things dun work good
if ($fruit_search==7) {$fruit=7;$fruit=13;}

Thanks for reading.

AstroTeg

Can you restate your question? Maybe in the form of a question might help. I don't know where you're having problems at...

hayato1

thanks for replying,

a user form search enter "7" in name=class
generate in return value="7" and value="13"
just for the "7" special case. other 1~100000... remain same way.
i have a long method of writing inside query. but i know it could be done easier without editing query

$class= $_GET['class'];
if ($class==7) {$condition="AND (class LIKE '7' OR class LIKE '13'";} else {$condition="ANDclass` LIKE '%'";}

$sql="SELECT * FROM abc
WHERE x like '%'
AND xy like '%'
AND xyz like '%'
............ alot here
$condition";

am I be ableto work things out easier?
by not writing in the query?

Weedpacket

If I'm understanding you right, then when the user asks for class "8", they get all the results where the class is 8; if they ask for class "9", they get all the results where the class is 9; but if they ask for class "7" they get all the results where the class is either 7 or 13.

$class=(int)$_GET['class'];
if ($class==7)
{    $condition="AND (`class`==7 OR `class`==13";
}
else
{
    $condition="AND `class`==$class";
}

Except where you write

$condition="AND class LIKE '%'";

makes it look like you don't want to use the class in your WHERE conditions at all. If that's true, then

$class=(int)$_GET['class'];
if ($class==7)
{    $condition="AND (`class`==7 OR `class`==13";
}

should be enough.

hayato1

thanks Weedpacket,
i'm done~!