search key help

[robin1983]

Hi, every one..
I need a simple help from you guys. Actually, i have simple query to search in my database. The scripts is some like this
[PHP] $sql = "SELECT * FROM courier_table WHERE $fieldname = '".$key."'";[/PHP]
Here $key is a variable where i stored the search value. Actully, i want to used like key word in place of = (egual to sign) in sql query.
Please do help me.

[MarkoKlacar]

Hi, every one..
I need a simple help from you guys. Actually, i have simple query to search in my database. The scripts is some like this
[PHP] $sql = "SELECT * FROM courier_table WHERE $fieldname = '".$key."'";[/PHP]
Here $key is a variable where i stored the search value. Actully, i want to used like key word in place of = (egual to sign) in sql query.
Please do help me.

Hi Robin,

I'm not quite sure I understood you question.
Does the query work today?

Cheers

[dafodil]

You can use this:
[php]
$sql = "SELECT * FROM courier_table WHERE $fieldname like '$key'";
[/php]


or if you have something like a textbox and you want to display every thing that the user type starting with that text.
you can do this:

[php]
$sql = "SELECT * FROM courier_table WHERE $fieldname like '$key%'";
[/php]

[robin1983]

Hi, its working .. thanks a lot ..

You can use this:
[php]
$sql = "SELECT * FROM courier_table WHERE $fieldname like '$key'";
[/php]


or if you have something like a textbox and you want to display every thing that the user type starting with that text.
you can do this:

[php]
$sql = "SELECT * FROM courier_table WHERE $fieldname like '$key%'";
[/php]

[dafodil]

You're welcome.
:)

Post again anytime.